Oracle CLOB parameter limit?

[Andrew]

Hey all,
I'm getting the following error when calling an Oracle9i proc from a .net
1.1 app, passing a clob parameter that is larger than ~32,000 characters:

ORA-01460: unimplemented or unreasonable conversion requested.

Is there a parameter size restriction for oracle procs? How do I pass in
a large clob to the database?

I'm using the MS managed provider for oracle, and the oracle9i drivers....

TIA,
Andrew

 

[Paul Clement]

¤ Hey all,
¤ I'm getting the following error when calling an Oracle9i proc from a .net
¤ 1.1 app, passing a clob parameter that is larger than ~32,000 characters:
¤
¤ ORA-01460: unimplemented or unreasonable conversion requested.
¤
¤ Is there a parameter size restriction for oracle procs? How do I pass in
¤ a large clob to the database?
¤
¤ I'm using the MS managed provider for oracle, and the oracle9i drivers....

I seem to recall that 32k was the limit when using an Oracle SP. This is an Oracle limitation.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)

 

[Andrew]

Thanks Paul. I've found a way around it though, sort of. If instead of
using a stored procedure, you just use straight sql, and pass the clob
parameter in that way, the limit is much higher. I've passed a 1 million
character clob this way with no problem.