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.

1 comment:

Sarkie said...

Any Help?

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