Re: ORA-01483: invalid length for DATE or NUMBER bind variable :(

"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
> 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 ?
>

Possible? yes.
Likely? no

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