Title: cursor and no data found
Hi List !
how can I can make a continue statement in my loop when a request return no data
e.g :
cursor c1 is .
for c in c1 loop
select a into v1
from table1
where a 1 and b 2 and ...
/* if my select into return no data ?
how can I tell him
BDY.RTF
Description: RTF file
;
end loop
NGUYEN Philippe (Cetelem) [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/15/02 03:38 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:cursor and no data found
Hi List !
how can I can make a continue
Hi Philippe
You can write the following after the select statement:
exception
when no_data_found then null;
regards,
Ams.
www.medicomsoft.com
Hi List !
how can I can make a continue statement in my loop when a request return
no data
e.g :
cursor c1 is .
for c in c1 loop
select
Philippe,
Youcould use PL/SQL exceptions.
Example :
for c in c1 loop
begin
select a into v1 from table1 where a 1 and b 2 and ...
exception
when no_data_found then
null;
end;
end loop;
Luc
"NGUYEN Philippe (Cetelem)" <[EMAIL PROTECTED]>wrote:
Hi List ! how can I can make a "continue"