OracleDataSource with CLOB raises ORA-01461

[hannes_a]

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

Code: Select all

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

[Shalex]

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?

[hannes_a]

today it works with the same sourcecode.
please forget it

thank you