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

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 19 Nov 2008 08:59:06 -0800
Message-ID: <1227113923.717959@bubbleator.drizzle.com>


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
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Wed Nov 19 2008 - 10:59:06 CST

Original text of this message