ORA-01461 :can bind a LONG value for insert...

[camdebuck]

I'm getting the following error message from oracle when trying to insert. This worked fine with an older version of DOAD. I'm using the lastest DOAD version. If I use an older version, all is fine. We are on Oracle 9.2.x.x.

The error message is:

ORA-01461 : can find a LONG vlaue only for insert into a LONG column

We also have the BytesPerCharacter set to bcAutoDetect.

Our NLS_LANG in the registry is set to:

AMERICAN_AMERICA.UTF8

 

[Marco Kalter]

What is your Delphi version?

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

 

[camdebuck]

Delphi 4.

 

[Marco Kalter]

Can you download the current registered Delphi 4 version and try again? This should fix the problem.

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

 

[camdebuck]

Okay, I've downloaded, uninstalled, reintalled the download and it appears to be working now.

What did you change?

 

[camdebuck]

Okay, I've downloaded, uninstalled, reintalled the download and it appears to be working now.

What did you change?

 

[Marco Kalter]

Oracle9i Release 2 has a bug that causes it to report an incorrect character size. This patch release works around that problem.

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