Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-24801 is I specify InitialLOBFetchSize

648434Jul 4 2008 — edited Jul 19 2008
Hi, I'm iterating through a few hundred thousand rows, each with two CLOB columns.

If I don't specify the InitialLOBFetchSize, everything works fine.

If I do specify the InitialLOBFetchSize, I get the exception
"ORA-24801: illegal parameter value in OCI lob function"
... when I call Read() on the OracleDataReader. It's always on the same row too.

Is there a way around this please? I'm using Oracle 11.1.0 odp.net client.

I even get this error if I specify a very small CLOB fetch size (32k).

Thanks,

Tom
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 16 2008
Added on Jul 4 2008
5 comments
3,293 views