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:30:28 -0800 (PST)
Message-ID: <b46f545f-2218-45bf-8cf1-859ba21f9dd4@k1g2000prb.googlegroups.com>


On Nov 19, 9:59 pm, DA Morgan <damor..._at_psoug.org> wrote:
> Prady The fire 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
>
> If what you are writing is a CURSOR LOOP or CURSOR FOR LOOP you
> are writing an obsolete syntax and should move up to using arrays.
>
> You can find examples here:http://www.psoug.org/reference/array_processing.html
> --
> Daniel A. Morgan
> Oracle Ace Director & Instructor
> University of Washington
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

.

Thank u to help me Received on Fri Nov 21 2008 - 11:30:28 CST

Original text of this message