Re: Regarding "how can i trap the empty explicit cursor value"
Date: Fri, 21 Nov 2008 09:30:28 -0800 (PST)
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