Re: intermittent ORA-1480 with proc++ code


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

.