Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: intermittent ORA-1480 with proc++ code

Re: intermittent ORA-1480 with proc++ code

From: <v.r.sankar_at_gmail.com>
Date: 20 Dec 2006 01:49:55 -0800
Message-ID: <1166608195.174146.213250@f1g2000cwa.googlegroups.com>

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>

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 - 03:49:55 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US