Skip to Main Content

SQL & PL/SQL

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!

Continue block after exception handling

fniazi4uJun 20 2015 — edited Jun 20 2015

Guys, In the below block ,

create or replace procedure proc_case

(p_in IN number)

is

begin

case p_in

when 1 then

dbms_output.put_line('its one');

when 2 then

dbms_output.put_line('its two');

end case;

dbms_output.put_line('after the exception handler');

exception when case_not_found then

dbms_output.put_line('its not found');

end;

When the procedure is executed as follows.

begin

proc_case(3);

end;

It displays the statement in the exception block, but after that it does not execute the statement after exception handler and exits from the block, How can I execute the statement which is after the end case statement. I am not using the Else statement in Case because I wanted to understand the logic of this block.

This post has been answered by Saubhik on Jun 20 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 18 2015
Added on Jun 20 2015
3 comments
1,400 views