Re: SQL Problem

Hi, Mike.

        If you can't use the NO_DATA_FOUND exception, then I would suggest doing one of the following...

• Create a cursor for the select statement and check to see if cursorname%NOTFOUND is true after you open it and attempt a fetch on it.
• First do a select count(*) into variable with your where condition and handle the 0 condition at that point.

Hope this helps,
-Jeff Guttadauro

On Thu, 12 Aug 1999 09:11:03 -0400, "Mike Heisz" <mheisz_at_rim.net> wrote:

>I am trying to write a query to return 1 value.
>Sometimes there is no value and the query returns no data. i.e
>select a
>from b
>where
>...... (here the conditions ensure that 1 or 0 rows are returned by the
>query)
>
>I need to supply a defeault value to be used when there are 0 rows returned.
>Is this possble and if so how do you do it?
>
>A couple of notes: This is part of a PL/SQL procedure but I can't use the
>NO_DATA_FOUND exception handler because I am dealing with files and this is
>used there.
>
>Thanks,
>
>Mike
>
>
>
Received on Thu Aug 12 1999 - 08:42:42 CDT