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.