Re: PL/SQL for Complex Reports? PL/SQL Tables?
From: Wardman <dennis_ward_at_bigfoot.com>
Date: Wed, 22 Apr 1998 08:29:15 +0800
Message-ID: <353D39DA.7A2A73EB_at_bigfoot.com>
Date: Wed, 22 Apr 1998 08:29:15 +0800
Message-ID: <353D39DA.7A2A73EB_at_bigfoot.com>
About your question to do with exception handling : You can use a BEGIN
END; block inside the program
and handle the execption for the inner block, so that the program does
not terminate if an exception is raised.
example :
procedure test is
begin
- code here
begin
- program code here
exception
when no_data_found then
- handle the exception
end;
- continue processing
exception
when others then
- handle exception end; -- procedure test
- continue processing
exception
when others then
- handle the exception
end;
- program code here
exception
when no_data_found then
I have written heaps of complex reports and extracts using PLSQL. If
you want to handle the
%NOT_FOUND then you can always open a cursor and use the fetch command
inside
a while loop.
open cursor_1;
while cursor1%FOUND loop
fetch cursor1 into v_variable1;
end loop;
BTW PLSQL tables are not that hard to use.
I hope some of this is some help. Received on Wed Apr 22 1998 - 02:29:15 CEST