ORA-01483: invalid length for DATE or NUMBER bind variable :(
From: pluton <zielonadupa_at_gazeta.pl>
Date: Tue, 13 May 2008 15:41:24 +0200
Message-ID: <g0c5q2$4m2$1@inews.gazeta.pl>
Date: Tue, 13 May 2008 15:41:24 +0200
Message-ID: <g0c5q2$4m2$1@inews.gazeta.pl>
Hi, I have the following table :
A INTEGER (-> 19300 )
B NUMBER(5) (->1)
CD DATE (->2008-05-10 10:51:14)
E INTEGER (-> 50070 )
NOTE VARCHAR2(100) ( -> 'short text, no national characters' )
I am trying to insert values as above (indicated by -> )
On the first database operation is successfull, on another I have ORA-01483.
The only difference between these two databases is
NLS_CHARACTERSET EE8ISO8859P2 (success)
NLS_CHARACTERSET AL32UTF8 (failure)
Is NLS_CHARACTERSET possible reason of problem ?
best regards
pluton
Received on Tue May 13 2008 - 08:41:24 CDT