Hello all
Im writing a c cartridge in OAS 4.0.7 with DB ORACLE 8 on SUN SOLARIS.
I try to execute some SQL statements with OCIStmtExecute.
The stmt : "SELECT aid,bid,cid FROM table WHERE pid=:mpid"
I have these two identical stmt , both for the same table with the same
variables (practically the same stmt.) just placed on different part of
the program.
They both succeed with the OCIHandleInitialize(),OCIStmtPrepare() ,
OCIDefineByPos() , OCIBindByPos and the OCIStmtHandleFree().
Just the OCIStmtExecute() works for one and the other returns with the
error :
ORA-01403 : no data found.
What can be the reason for this problem and what are your suggestions
for solving it.
Thank you.
uri
e-mail:uri_at_trans-planet.com
Received on Thu Apr 29 1999 - 18:58:46 CDT
