OracleDataSource with CLOB raises ORA-01461

OracleDataSource with CLOB raises ORA-01461

Postby hannes_a » Mon 09 Aug 2010 10:34

I want to update a CLOB field in a ASPxGridView (ASP.NET) but during update it raises
ORA-01461: can bind a LONG value only for insert into a LONG column

I read some posts in your forum, and most of the time the solution was to set unicode=true, but I have databases with/without unicode. And with unicode=true it raises
ORA-01483: invalid length for DATE or NUMBER bind variable

Because of this two reasons, unicode is no solution for me.

How to solve this ? A small codeexample would be very usefull.
Thank you !

Code: Select all
UpdateCommand="UPDATE INSTBASE SET REGEN_CONTENT = :REGEN_CONTENT WHERE ((ID = :Original_ID))">
     
         
         
     

   

Code: Select all
CREATE TABLE INSTBASE
(
  ID                    NUMBER(12),
  REGEN_CONTENT         CLOB
)
hannes_a
 
Posts: 77
Joined: Sun 22 Jan 2006 20:44
Location: munic

Postby Shalex » Tue 10 Aug 2010 14:17

Please give us the following information:
1) the exact version of dotConnect for Oracle you are using. You can find it via the Tools > Oracle > About menu of Visual Studio;
2) the exact version of the DevExpress ASPxGridView component (a pop-up menu in Toolbox). Have you tried Microsoft's GridView? Does the problem persist in this case as well?
3) the version of your Visual Studio;
4) are you working in the Direct mode or in the OCI mode of dotConnect for Oracle?
5) please send us your test data you are using to raise the mentioned errors. You are setting your test data in design time via the Edit menu of ASPxGridView, aren't you?
Shalex
Devart Team
 
Posts: 7527
Joined: Thu 14 Aug 2008 12:44

Postby hannes_a » Tue 10 Aug 2010 17:22

today it works with the same sourcecode.
please forget it

thank you
hannes_a
 
Posts: 77
Joined: Sun 22 Jan 2006 20:44
Location: munic


Return to dotConnect for Oracle