Re: intermittent ORA-1480 with proc++ code

In message <1166581906.923465.145430_at_80g2000cwy.googlegroups.com>, v.r.sankar_at_gmail.com writes
>Hello,
>
>I have the following piece of code in my server written in
>C++ (CC: Sun WorkShop 6 update 2 C++ 5.3 Patch 111685-12 2002/12/16)
>ProC++ (Pro*C/C++: Release 8.1.7.4.0)
>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>RWCString tmp = ""; //Rogue wave String
>EXEC SQL BEGIN DECLARE SECTION;
> char dbColValue[10];
> short tmpnumber;
>
> short tmpnumberInd;
> short dbColValueInd;
>EXEC SQL END DECLARE SECTION;
>
>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>