 | |
Regarding "how can i trap the empty explicit cursor value"
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: Regarding "how can i trap the empty explicit cursor value" -
11-21-2008
, 12:29 PM
|
On Nov 18, 4:25 am, Prady The fire <er.pradau... (AT) gmail (DOT) 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 -- |
#12
| |||
| |||
|
|
On Nov 18, 4:25 am, Prady The fire <er.pradau... (AT) gmail (DOT) 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 -- |
#13
| |||
| |||
|
|
On Nov 18, 4:25 am, Prady The fire <er.pradau... (AT) gmail (DOT) 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 -- |
#14
| |||
| |||
|
|
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 damor...@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Groupwww.psoug.org |
Thank u to help me
#15
| |||
| |||
|
|
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 damor...@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Groupwww.psoug.org |
Thank u to help me
#16
| |||
| |||
|
|
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 damor...@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Groupwww.psoug.org |
Thank u to help me
#17
| |||
| |||
|
|
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 damor...@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Groupwww.psoug.org |
Thank u to help me
#18
| |||
| |||
|
|
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 |
data found" is something different than a NULL value for a column in the
result set.
Cheers
ribert
#19
| |||
| |||
|
|
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 |
data found" is something different than a NULL value for a column in the
result set.
Cheers
ribert
#20
| |||
| |||
|
|
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 |
data found" is something different than a NULL value for a column in the
result set.
Cheers
ribert
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.