Devart Forums

Posted: **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

CREATE TABLE INSTBASE
(
  ID                    NUMBER(12),
  REGEN_CONTENT         CLOB
)

Posted: **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?

Posted: **Tue 10 Aug 2010 17:22**

today it works with the same sourcecode.
please forget it

thank you

Devart Forums

OracleDataSource with CLOB raises ORA-01461

OracleDataSource with CLOB raises ORA-01461