Page 1 of 1

How to Write CLOBs

Posted: Thu 07 Sep 2006 13:26
by mhess
We are currently migrating our application to the CoreLab Driver. When we try to insert a row which contains a CLOB > 4000 characters, we get the following error:

Ora-01461: Can Bind A Long Value Only For Insert Into A Long Column

We are using a DataSet / DataAdapter for the update. This means that we need to use SQL alone for the update.

Please Help
Kind Regards
Matthias

Posted: Thu 07 Sep 2006 14:51
by mhess
I figured it out.

When I set the Parameter.OracleDbType Property to Clob, everything works fine.

Kind regards
Matthias

Posted: Thu 07 Sep 2006 15:09
by Alexey
Right.