Page 1 of 1
ORA-01461 Error
Posted: Fri 17 Feb 2012 12:25
by 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
Posted: Fri 17 Feb 2012 13:14
by AlexP
Hello,
Please send me results of the following queries:
Code: Select all
SELECT USERENV ('language') from dual;
SELECT * FROM V$NLS_PARAMETERS;
Posted: Fri 17 Feb 2012 13:27
by 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
Posted: Sat 18 Feb 2012 08:58
by 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.
Posted: Mon 20 Feb 2012 13:55
by zguven
I need your help.
Please quickly!!!
Re: ORA-01461 Error
Posted: Tue 16 Jul 2013 14:28
by 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
Re: ORA-01461 Error
Posted: Fri 19 Jul 2013 10:43
by AlexP