Oracle CLOB parameter limit?

  • Thread starter Thread starter Andrew
  • Start date Start date
A

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
 
¤ 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)
 
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.
 
Back
Top