Rom's Rants

Free-Roaming Hostility From A QA/Developer Perspective.

Monday, January 14, 2008

Oracle Error ORA-01460

Symptom: When calling an Oracle stored procedure with either a CLOB or an NCLOB parameter using the Oracle provider that ships with the .NET Framework, you get the following error message:

ORA-01460: unimplemented or unreasonable conversion requested

Cause: You are passing more than 32Kb of data to either a CLOB or NCLOB parameter.

I'm looking for a workaround.

Update: Evidently, you have to insert a small record into the database, then open that row in an OracleDataReader using a "SELECT * FROM ___ FOR UPDATE," get the LOB and then stream into the LOB. Thanks to Sarkie for shortcutting my search.

posted by Michael Russell at 1/14/2008 09:31:00 AM

1 Comments:

Blogger Sarkie said...

Any Help?

http://bembengarifin-tech.blogspot.com/2008/01/biztalk-oracle-adapter-adonet.html

1/14/2008 11:04 AM  

Post a Comment

Links to this post:

Create a Link

<< Home