How to Write CLOBs

How to Write CLOBs

Postby 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
 
Posts: 4
Joined: Thu 07 Sep 2006 13:19

Postby 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
mhess
 
Posts: 4
Joined: Thu 07 Sep 2006 13:19

Postby Alexey » Thu 07 Sep 2006 15:09

Right.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for Oracle