Xref: alice comp.databases.oracle.server:47785
Path: alice!news-feed.fnsi.net!newspump.monmouth.com!newspeer.monmouth.com!uunet!nyc.uu.net!ffx.uu.net!in2.uu.net!news.inter.net.il!not-for-mail
From: uri bargil <uri@trans-planet.com>
Newsgroups: comp.databases.oracle.server
Subject: ERROR ORA-01403 : no data found
Date: Fri, 30 Apr 1999 02:58:46 +0300
Organization: Internet Gold, ISRAEL
Lines: 18
Message-ID: <3728F236.19CAB27D@trans-planet.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: news2.inter.net.il 925430340 13451 192.117.160.194 (29 Apr 1999 23:59:00 GMT)
X-Complaints-To: abuse@inter.net.il
NNTP-Posting-Date: 29 Apr 1999 23:59:00 GMT
X-Mailer: Mozilla 4.51 [en] (WinNT; I)
X-Accept-Language: en

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@trans-planet.com