How to Write CLOBs

mhess · Post by **mhess** » Thu 07 Sep 2006 13:26

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

mhess · Post by **mhess** » Thu 07 Sep 2006 14:51

I figured it out.

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

Kind regards
Matthias

Alexey · Post by **Alexey** » Thu 07 Sep 2006 15:09

Right.