ORA-01461 Error

[zguven]

We use ODAC 8.1.4 for Delphi XE2.
Users recieve ORA-01461 Error.
Oracle 10.2.0.1 with turkish character set.

old program running with Odacv610 + delphi 7 without any problem.

We want to use 6.10 for Delphi XE2.
We dont'want 8.1.4 for Delphi XE2.

I'm sick of errors

[AlexP]

Hello,

Please send me results of the following queries:

Code: Select all

SELECT USERENV ('language') from dual;

SELECT * FROM V$NLS_PARAMETERS;

[zguven]

SELECT USERENV ('language') from dual;

TURKISH_TURKEY.WE8ISO8859P9
________________

SELECT * FROM V$NLS_PARAMETERS;

NLS_LANGUAGE TURKISH
NLS_TERRITORY TURKEY
NLS_CURRENCY TL
NLS_ISO_CURRENCY TURKEY
NLS_NUMERIC_CHARACTERS ,.
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD/MM/RRRR
NLS_DATE_LANGUAGE TURKISH
NLS_CHARACTERSET WE8ISO8859P9
NLS_SORT BINARY_AI
NLS_TIME_FORMAT HH24:MI:SSXFF
NLS_TIMESTAMP_FORMAT DD/MM/RRRR HH24:MI:SSXFF
NLS_TIME_TZ_FORMAT HH24:MI:SSXFF TZR
NLS_TIMESTAMP_TZ_FORMAT DD/MM/RRRR HH24:MI:SSXFF TZR
NLS_DUAL_CURRENCY YTL
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE

[zguven]

If you have defined field in the table varchar2. (2000 or 4000)
Even though this error is a few characters.

Error only insert operation

If save it as an empty, no error when updating.

[zguven]

I need your help.

Please quickly!!!

[zguven]

Hi,

Errors raised when inserting varchar2 data contains CR LF.
When Sessions.ConvertEOL setted "false" running without any error. But CR LF characters removed.

We use onnewrecord event for varchar2 field set template string contains multiple CR LF characters.

We need CR LF Characters.

DelphiXE2+8.1.6.12

[AlexP]

Hello,

I have replied you at our forum http://forums.devart.com/viewtopic.php? ... 363#p93363