Re: PL/SQL cursor

Paul,

    You can also try using what is called an outer join. To accomplish this I'll use your example:

cursor c(cur_id in varchar2) is select myparent from myfamily where myparent_id = cur_id(+)

    You will need to check to make sure that you aren't getting nulls with any of IS NULL, IS NOT NULL and NVL() when you are expecting there to be data.

• Matt --

Phong Paul Tran wrote in message
<35228F1C.6F17CE29_at_houston.geoquest.slb.com>...
>I have a cursor defined below:
>
>cursor c(cur_id in varchar2) is select myparent from myfamily where
>myparent_id = cur_id;
>
>My problem is the select statement for this cursor only works on
>non-null cur_id values. _id;
>
>
>How do I create a cursor that will work on both null and not null
>cur_id?
>
>Thank you much for your help.
>
>
>Paul Tran
>pptran_at_slb.com
>
>
>
>
Received on Wed Apr 01 1998 - 00:00:00 CST