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

From: Mark D Powell <>
Date: Tue, 18 Nov 2008 06:44:21 -0800 (PST)
Message-ID: <>

On Nov 18, 4:25 am, 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

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;
    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

Original text of this message