Re: intermittent ORA-1480 with proc++ code

From: <v.r.sankar_at_gmail.com>
Date: 1 Jan 2007 21:28:27 -0800
Message-ID: <1167715707.652649.143490_at_i12g2000cwa.googlegroups.com>


[Quoted] Thanks. I will try this and let you know.

Ravi.

Jim Smith wrote:
> >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 !!!
> >
>
> That means the problem could be here.
>
>
> if (dbColValueInd == -1)
> tmp = "";
> else
> tmp = RWCString(dbColValue).strip();
>
> If Column1 is null, the dbCalValueInd will be -1 and 'tmp=""' will be
> executed. What is in tmp after this? Do you need to cast the empty
> string to RWCString when you assign it?
>
> If you want to use a null value in a query or update, you should use an
> indicator and set it to -1;
>
> e.g.
>
> insert into tables values (:dbColValue:dbColValueInd);
> --
> Jim Smith
> Ponder Stibbons Limited <http://oracleandting.blogspot.com/>
> RSS <http://oracleandting.blogspot.com/atom.xml>
Received on Tue Jan 02 2007 - 06:28:27 CET

Original text of this message