Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

exception handling in calling procedure

636086Mar 4 2009 — edited Mar 4 2009
Hi,

i have a package where currently am making calls to private procedures from public procedure.

and the senario is:-

create package body p_tst
is

ex_failed exception;

-- this is private proc
procedure p_private
is
begin
.
.
raise ex_failed;
exception
when ex_failed
then
raise;
.........
end p_private;

procedure p_public
is
begin
....
-- nomaking call to private
-- procedure
p_private;

-- here i need to catch
-- the raised exception
-- passed from the called
-- procedure
when ex_failed
...
end p_public;

end;

basically i want to catch the exception being passed from called procedure to calling procedure, and raise the same exception in calling procdure.

is it possible to catch the same exception in the calling procedure?
This post has been answered by 654603 on Mar 4 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 1 2009
Added on Mar 4 2009
3 comments
423 views