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!

Can Ref Cursor Handle a CLOB Column

412971Nov 23 2004 — edited Jan 6 2005
All,

I am opening a ref cursor from a PL/SQL procedure that contains one column whose datatype is CLOB. I am using ODP.NET on the client. I keep getting the following error:

ORA-00932: inconsistent datatypes: expected - got CLOB

Do I need to prep this column in advance or can ODP.NET's ref cursor implementation handle a resultset containing LOB column(s)?

Thanks for your assistance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 3 2005
Added on Nov 23 2004
9 comments
4,375 views