CODEWITHSUNDEEP
exceptionplsql
Rashmi
Rashmi

Reputation: 3

What happens when a exception occurs in exception block

suppose in my procedure, error occurred and it went to exception block. while entering the logs for error occurred another error takes placein exception block itself.

What happens then ...

Upvotes: 0

Views: 86

Answers (1)

Tony Andrews
Tony Andrews

Reputation: 132580

The easiest way to find out is surely to try it?

declare
   dummy integer;
begin
   select 99 into dummy from all_objects; -- Will raise TOO_MANY_ROWS
exception 
   when too_many_rows then
      select 77 into dummy from dual where 2=3; -- Will raise NO_DATA_FOUND
end;    
/

When you run that you will get:

ORA-01403: no data found
ORA-06512: at line 8

Upvotes: 1

Related Questions