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

On May 13, 6:41 am, "pluton" <zielonad..._at_gazeta.pl> wrote:
> 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

Please post your exact Oracle version and see metalink Note:465497.1 (bug 6085625) and Note:444045.1 (not a bug 5241003).

My guess is you have different drivers or patches FWIW.

jg

--
@home.com is bogus.
http://www.signonsandiego.com/uniontrib/20080513/news_1b13hp.html