Re: intermittent ORA-1480 with proc++ code
From: <v.r.sankar_at_gmail.com>
Date: 21 Dec 2006 19:21:58 -0800
Message-ID: <1166757718.071527.50240_at_73g2000cwn.googlegroups.com>
Date: 21 Dec 2006 19:21:58 -0800
Message-ID: <1166757718.071527.50240_at_73g2000cwn.googlegroups.com>
> >>"Column1 is 9 characters in length. VARCHAR2(9)."
> Wrong. Column1 is 9 BYTES length. Depending on the characterset you can
> find strings with 9 letters which are longer than 9 bytes! Try DUMP()
> function.
>
> HTH.
>
> Cheers.
>
> Carlos.
Good point ! I never thought of it !! But strangely, the code is breaking when the Column1 is null, not when it has 9 letter data !!! Received on Fri Dec 22 2006 - 04:21:58 CET