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

On Nov 18, 4:25*am, Prady The fire <er.pradau... (AT) gmail (DOT) com> wrote:
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).

LOOP
FETCH c1 INTO my_ename, my_salary;
IF c1%FOUND THEN -- fetch succeeded
<snip>
<<

HTH -- Mark D Powell --

On Nov 18, 4:25*am, Prady The fire <er.pradau... (AT) gmail (DOT) com> wrote:
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).

LOOP
FETCH c1 INTO my_ename, my_salary;
IF c1%FOUND THEN -- fetch succeeded
<snip>
<<

HTH -- Mark D Powell --

On Nov 18, 4:25*am, Prady The fire <er.pradau... (AT) gmail (DOT) com> wrote:
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).

LOOP
FETCH c1 INTO my_ename, my_salary;
IF c1%FOUND THEN -- fetch succeeded
<snip>
<<

HTH -- Mark D Powell --

On Nov 18, 4:25*am, Prady The fire <er.pradau... (AT) gmail (DOT) com> wrote:
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).

LOOP
FETCH c1 INTO my_ename, my_salary;
IF c1%FOUND THEN -- fetch succeeded
<snip>
<<

HTH -- Mark D Powell --

Prady The fire wrote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Prady The fire wrote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Prady The fire wrote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Prady The fire wrote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

On Nov 18, 7:44 pm, Mark D Powell <Mark.Pow... (AT) eds (DOT) com> wrote:
Thank u to helping me.