ORA-01461: can bind a LONG value only for insert into a LONG column

[Murat Memioglu]

Hi guys,

I am getting
ORA-01461: can bind a LONG value only for insert into a LONG column
when I want to update a varchar(60) field in a table through doa (with a TOracleDataset).

There is no LONG field in the table. And I get this error not only on this table. I get this in every update on every table I use.

I tried running the sql which doa uses to update which I got from Oracle Monitor tool for doa, in sql plus. It works just fine.

The annoying is, the program works everywhere with no doubt.

The configurations:
Oracle 9.2.0.4.0
W2000 server
doa 3.4
and locale of server is Azeri(Latin) I don't know if this property has an impact.

 

[Marco Kalter]

Have you set TOracleSession.BytesPerCharacter to bcAutoDetect?

 

[Murat Memioglu]

I did nothing with BytesPerCharacter property but I tested it and it worked.

Thanks alot Marco.