Re: Regarding "how can i trap the empty explicit cursor value"

From: Prady The fire <er.pradauman_at_gmail.com>
Date: Fri, 21 Nov 2008 09:29:42 -0800 (PST)
Message-ID: <b437f65c-03ce-4bdd-81b8-eea04b63813e@35g2000pry.googlegroups.com>


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;
> LOOP
> FETCH c1 INTO my_ename, my_salary;
> IF c1%FOUND THEN -- fetch succeeded
> <snip>
> <<
>
> HTH -- Mark D Powell --

Thank u to helping me. Received on Fri Nov 21 2008 - 11:29:42 CST

Original text of this message