Re: No Data found error

Naren wrote:
> 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
what are the values of d_a and d_b?
I don't see a declarion like

d_a	number := 12;
d_b	number := 4;

-- 
Regards, Frank van Bortel