Re: ORA-01483: invalid length for DATE or NUMBER bind variable :(
Date: Tue, 13 May 2008 14:08:17 GMT
"pluton" <zielonadupa_at_gazeta.pl> wrote in news:g0c5q2$4m2$1_at_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
> The only difference between these two databases is
> NLS_CHARACTERSET EE8ISO8859P2 (success)
> NLS_CHARACTERSET AL32UTF8 (failure)
> Is NLS_CHARACTERSET possible reason of problem ?
With Oracle characters between single quote marks are STRINGS!
'This is a string, 2008-05-15, & not a date datatype'
When you want/need a date datatype use TO_DATE() function. Received on Tue May 13 2008 - 09:08:17 CDT