R
ravi
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 = "";
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;
if (dbColValueInd == -1)
tmp = "";
else
tmp = RWCString(dbColValue).strip();
strcpy(dbColValue,tmp);
select 1 into :tmpnumber:tmpnumberInd from Table2 where Column2 =
:dbColValue;
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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.
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 = "";
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;
if (dbColValueInd == -1)
tmp = "";
else
tmp = RWCString(dbColValue).strip();
strcpy(dbColValue,tmp);
select 1 into :tmpnumber:tmpnumberInd from Table2 where Column2 =
:dbColValue;
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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.