No Data found error

From: Naren <naren_on_net_at_hotmail.com>
Date: 28 Nov 2003 05:33:42 -0800
Message-ID: <825c72b.0311280533.772e8448_at_posting.google.com>

Hi,

I am a newbie to Oracle and stored procedures. Hence this question comes up. The complete scenario is like this. We have a multithreaded application using pthreads on HP-UX machine. We are connecting to Oracle database 8.1.7. The application calls stored procedures on database using OCI calls. It is also ensured that the our application is thread safe.

When a particular procedure is called, a SQL select statment returns an exception NO DATA FOUND. However when we connect though SQL and try executing the same SQL select query , it is found that the data is present. Also other SQL select statements in the same procedure prior to this one work fine. However one difference is there. The flow of the SQL in the proc is as follows
 BEGIN
  SELECT
  a,
  b,
  INTO
  d_a,
  d_b,
  FROM X
  WHERE condition1 = 10
  AND condition2= 3;
  EXCEPTION

       WHEN NO_DATA_FOUND THEN 
         raise_application_error (-20033, '99991, no data found -- 

');
  END;     BEGIN
  SELECT m INTO d_m
  FROM Y
  WHERE condition3= d_a
  AND condition4 = d_b;
  EXCEPTION

       WHEN NO_DATA_FOUND THEN 
         raise_application_error (-20033, '99992, no data found ');

  END; --> problem occurs here

Could anyone please tell me what can be cause of this error.

Thanks in advance
Naren Received on Fri Nov 28 2003 - 14:33:42 CET