Re: Regarding "how can i trap the empty explicit cursor value"
Date: Tue, 18 Nov 2008 06:44:21 -0800 (PST)
On Nov 18, 4:25 am, Prady The fire <er.pradau..._at_gmail.com> wrote:
> 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
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).
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