Re: Regarding "how can i trap the empty explicit cursor value"
From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Tue, 18 Nov 2008 06:44:21 -0800 (PST)
Message-ID: <2dcef1b4-db41-4e97-80e2-1b2097699fe8@o4g2000pra.googlegroups.com>
Date: Tue, 18 Nov 2008 06:44:21 -0800 (PST)
Message-ID: <2dcef1b4-db41-4e97-80e2-1b2097699fe8@o4g2000pra.googlegroups.com>
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 -- Received on Tue Nov 18 2008 - 08:44:21 CST