ORA-1722 | Rocket Forum

Hi,

I have a cobol program that use ESQL in Server for Cobol 5.1 , the oracle odbc client x32 has been migrated from 11.02.00.01 to 12.01.00.01.

I did not recompile the program, I use the same dll, and the unique field defined numeric is:

10 RAG-IMP-CNT-EU PIC S9(13)V9(2) USAGE COMP-3.

the column of the table is:

RAG_IMP_CNT_EU NUMBER (15, 2) NOT NULL

if I use in a SELECT works fine,instead if I use the same field with an INSERT\\UPDATE oracle odbc driver 12 give ORA1722.

What can I check ?

thank

bye

#ORA1722

Page 1 / 1

Hi,

I have a cobol program that use ESQL in Server for Cobol 5.1 , the oracle odbc client x32 has been migrated from 11.02.00.01 to 12.01.00.01.

I did not recompile the program, I use the same dll, and the unique field defined numeric is:

10 RAG-IMP-CNT-EU PIC S9(13)V9(2) USAGE COMP-3.

the column of the table is:

RAG_IMP_CNT_EU NUMBER (15, 2) NOT NULL

if I use in a SELECT works fine,instead if I use the same field with an INSERT\\UPDATE oracle odbc driver 12 give ORA1722.

What can I check ?

thank

bye

Hi ,

I have solved, this difference in oracle NLS_SESSION_PARAMETERS,

this settings give ora 1722 in client 12g:

LANGUAGE = ITALIAN_ITALY.AL32UTF8

NLS_NUMERIC_CHARACTERS = ,.

this work fine in client 11g:

LANGUAGE = AMERICAN_AMERICA.AL32UTF8

NLS_NUMERIC_CHARACTERS = .,

bye

Sign up