Re: ORA-01483: invalid length for DATE or NUMBER bind variable :(
Date: Tue, 13 May 2008 16:59:19 +0200
> 'This is a string, 2008-05-15, & not a date datatype'
> When you want/need a date datatype use TO_DATE() function.- Hide quoted
> text -
So WHY it works on one database, and does not on another ? I know to_date function very well.
> Pluton, you really need to post the actual insert or update statement
Its unfortunately NOT so simple. I am inserting values using Oracle, ODBC and DB2/CLI Template Library, Version 4.0.101, by Sergei Kuchin
> so that board readers can see exactly what you are doing.
If I had known what I am doing , I wouldn't have asked stupid questions here :)
> What is the
default date format setting on each database? In each session where you perform the insert? A difference in the nls_date_format database or OS environment variable settings could easily cause this error with a date value.
NLS_LANGUAGE POLISH NLS_TERRITORY POLAND NLS_CURRENCY zl NLS_ISO_CURRENCY POLAND NLS_NUMERIC_CHARACTERS , NLS_CALENDAR GREGORIAN NLS_DATE_FORMAT RR/MM/DD NLS_DATE_LANGUAGE POLISH NLS_CHARACTERSET EE8ISO8859P2 NLS_SORT POLISH NLS_TIME_FORMAT HH24:MI:SSXFF NLS_TIMESTAMP_FORMAT RR/MM/DD HH24:MI:SSXFF NLS_TIME_TZ_FORMAT HH24:MI:SSXFF TZR NLS_TIMESTAMP_TZ_FORMAT RR/MM/DD HH24:MI:SSXFF TZR NLS_DUAL_CURRENCY zl NLS_NCHAR_CHARACTERSET AL16UTF16 NLS_COMP BINARY NLS_LENGTH_SEMANTICS BYTE NLS_NCHAR_CONV_EXCP FALSE
> For a problem with a number I need to see the SQL to
form any ideas.
I desperately need it too :)
pluton Received on Tue May 13 2008 - 09:59:19 CDT