Error ORA-01461 on update

Exsyde · Post by **Exsyde** » Fri 11 Mar 2005 11:41

Hello,

I have the next error (Error ORA-01461: can bind a LONG value only for insert into a LONG column) when I update a record on an UTF8 Oracle database (this problem does not occured when the charset is WE8MSWIN1252).

I Used a prepared statement to update the table with a command like
UPDATE TABLE1 SET COL3 = :1
WHERE COL1 = :2
AND COL2 = :3
AND COL4 = :4

The parameters are :
:1 (String[12],IN) = 'Fiche témoin'
:2 (String[5],IN) = '36741'
:3 (String[1],IN) = '1'
:4 (String[14],IN) = 'Fiche témoinxx'

Table "Table1" is created as
CREATE TABLE "TABLE1" (
"COL1" NUMBER(10) NOT NULL,
"COL2" NUMBER(10) NOT NULL,
"COL3" VARCHAR2(2500) NULL)

My params for the SQLConnection (TCRSQLConnection) are :
BlobSize=-1
DataBase=exs
DriverName=Oracle (Core Lab)
ErrorResourceFile=
LocaleCode=0000
Password=exs
Oracle TransIsolation=ReadCommited
User_Name=exsusr
LongStrings=True
EnableBCD=True
InternalName=
UseQuoteChar=False
CharLength=0
Charset=WE8MSWIN1252

The NLS_LANG or the Oracle client is set to FRENCH_FRANCE.WE8MSWIN1252 and the database is set to AMERICAN_AMERICA.UTF8

Have you an idea?

Regards

Alain

Paul · Post by **Paul** » Tue 15 Mar 2005 12:45

Thank you for information. We reproduced your problem and fixed it. This fix will be included in the
next DbxOda build.

Exsyde · Post by **Exsyde** » Wed 16 Mar 2005 10:07

Thank you Paul.

It is possible to have an "unofficial" build or patch of the driver with the correction of this problem?

Regards

Alain

Paul · Post by **Paul** » Fri 18 Mar 2005 16:02

We are planning to release DbxOda next week.

Exsyde · Post by **Exsyde** » Thu 07 Apr 2005 15:16

Hello,

In your last post, you wrote that the DbxOda will be released in end of March, but I do not find any trace of this release. Does it exist? Otherwise, could you give us a date?
Best regards,
Manu

Exsyde · Post by **Exsyde** » Thu 07 Apr 2005 15:20

Sorry, I just find it.

Thanks a lot.
Manu