Re: Regarding "how can i trap the empty explicit cursor value"
Date: Fri, 21 Nov 2008 09:29:42 -0800 (PST)
On Nov 18, 7:44 pm, Mark D Powell <Mark.Pow..._at_eds.com> wrote:
> On Nov 18, 4:25 am, Prady The fire <er.pradau..._at_gmail.com> wrote:
> > Hi,
> > i write a explicit cursor but for the some condition data not
> > available for that cursor.
> > at that time how can i trap the NULL value for the further processpls
> > help me
> > Thanks
> In your PL/SQL manual look up cursor attributes. There are several
> that can be used to obtain information about the status of a cursor
> (implicit and explicit).
> OPEN c1;
> FETCH c1 INTO my_ename, my_salary;
> IF c1%FOUND THEN -- fetch succeeded
> HTH -- Mark D Powell --
Thank u to helping me. Received on Fri Nov 21 2008 - 11:29:42 CST