A Brief Introduction to Oracle Database PL/SQL Exception Handling Code

We know that any programming language can handle exceptions, such as Java and C ++.Oracle DatabaseHow to handle exceptions? In fact, the handling of Oracle Database exceptions is actually very simple. This article givesPL/SQL Exception HandlingThe Code is as follows:

 
 

  
  
declare    
  
  
 
  
  
e_1 exception;    
  
  
 
  
  
begin    
  
  
 
  
  
begin  
  
  
 
  
  
dbms_output.put_line('0000000');    
  
  
 
  
  
raise e_1;    
  
  
 
  
  
exception when e_1 then null;    
  
  
 
  
  
dbms_output.put_line('aaaaaaaaa');    
  
  
 
  
  
end;    
  
  
 
  
  
dbms_output.put_line('bbbbbbbbb');    
  
  
 
  
  
begin  
  
  
 
  
  
raise e_1;    
  
  
 
  
  
exception when e_1 then null;    
  
  
 
  
  
dbms_output.put_line('ccccccccc');    
  
  
 
  
  
end;    
  
  
 
  
  
dbms_output.put_line('ddddddddd');    
  
  
 
  
  
exception when others then  
  
  
 
  
  
rollback;  
  
  
 
  
  
end; 
 
 

The above is the Oracle database Pl/SQL Exception Handling Code, hope to have some gains for you, if you want to know