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

[KanwarNasir]

My application that I designed for Oracle 8i database generates the following error when it is run against Oracle 9i database. The error pops up when Post method is used to save an Inserted record using the TOracleDataset. Inserting a record through SQL statement (Execute method) works fine.

Are DOA components compatible with Ora9? If not, when can I expect DOA upgrade?

Thanks.

 

[Marco Kalter]

You will need to download the latest Direct Oracle Access 3.4.6.4 version to fix this problem.

------------------
Marco Kalter
Allround Automations

 

[oradba2003]

we got the same ...

Delphi7 Ent, DOA 3.4.6.4, Oracle 9.2.0.3.0

create table test(
id number(18),
name1 varchar(32),
name2 varchar(16)
);

with OracleQuery1 do
begin
SQL.Text:='insert into test valuesid,:name1,:name2)';
DeclareVariable('ID',otInteger);
DeclareVariable('NAME1',otString);
DeclareVariable('NAME2',otString);
SetVariable('ID',1);
SetVariable('NAME1','VALUE#1');
SetVariable('NAME2','VALUE#2');
Execute;
end;

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

... you may reproduce this bug

 

[Marco Kalter]

It may be necessary to set TOracleSession.BytesPerCharacter to bcAutoDetect, or to the correct explicit value.

------------------
Marco Kalter
Allround Automations

 

[oradba2003]

Thank you, Marco!
we have
nls_lang=russian_cis.cl8mswin1251
and
TOracleSession.BytesPerCharacter=bc2Bytes
works fine
Dan