Re: ORA-01483: invalid length for DATE or NUMBER bind variable :(
Date: Tue, 13 May 2008 09:09:34 -0700 (PDT)
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
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.
-- @home.com is bogus. http://www.signonsandiego.com/uniontrib/20080513/news_1b13hp.htmlReceived on Tue May 13 2008 - 11:09:34 CDT