Re: intermittent ORA-1480 with proc++ code

I did try this one out. Tried on a different table in testing environment. Couldn't replicate the problem. The assignment of null to RWCString is not a problem. Apparently, there were some oracle patches missing in production. Lets hope it fixes the problem.

On Jan 2, 10:28 am, v.r.san..._at_gmail.com wrote:
> 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 Mon Jan 08 2007 - 11:30:43 CET