how to test cursor null and then continue...
490078Jan 26 2009 — edited Jan 26 2009Hi all,
I do a loop upon a cursor with argument :
declare
cursor my_cursor(j date) is select fact_id from factures where fact_date = j;
begin
for c in my_cursor(jour) lopp
dbms_output.put_line('data found');
end loop;
when no_data_found then dbms_output.put_line('data not found'); -- this dosen't work !
end;
/
My problem is when the cursor contains no data for a given date, I'd like to write a message for inform me.
How do I do it ?
TIA.
Yang