Re: intermittent ORA-1480 with proc++ code

Jim Smith wrote:
> >select Column1 into :dbColValue:dbColValueInd from Table1;
>
> What is the definition of Column1?
> If it can contain 10 characters, then there would be no room in
> dbColValue for the 0x00 string terminator.
>
> --
> Jim Smith
> Ponder Stibbons Limited <http://oracleandting.blogspot.com/>
> RSS <http://oracleandting.blogspot.com/atom.xml>

[Quoted] [Quoted] Column1 is 9 characters in length. VARCHAR2(9). Wherever dbColValue is referenced the column value is of same signature. These columns are infact representing the same data entity but in different tables.

 My guess is that strcy(oracle_char_var,RWCString) is not working properly.
Both are structures and not char *. I am not sure if the implicit cast is working properly.
Also, I am not sure if it is the best way to copy the information. Unit testing this part alone produced proper results without any anomalies.

The frustrating part is that it is intermittent and hence finding it extremely hard to replicate. Any ideas for replication are also appreciated.

Do you see any memory leakage problems with the code? Received on Wed Dec 20 2006 - 10:49:55 CET