intermittent ORA-1480 with proc++ code

From: <v.r.sankar_at_gmail.com>
Date: 19 Dec 2006 18:31:46 -0800
Message-ID: <1166581906.923465.145430_at_80g2000cwy.googlegroups.com>

Hello,

[Quoted] 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; [Quoted] [Quoted] select Column1 into :dbColValue:dbColValueInd from Table1;

if (dbColValueInd == -1)

    tmp = "";
else

   tmp = RWCString(dbColValue).strip();

strcpy(dbColValue,tmp);

select 1 into :tmpnumber:tmpnumberInd from Table2 where Column2 = :dbColValue;
 also
insert into tables values(<other cols>,:dbColValue);

Both are failing intermittently

---

I am getting intermittent ORA-1480 (Bind value not terminated by null) error. A similar piece of code is working fine elsewhere. Cant find a mistake in the code. Also, I am not able to replicate this error, but is occurring intermittently.

Any help/ideas is highly appreciated.

Regards,
Ravi. Received on Wed Dec 20 2006 - 03:31:46 CET