<div id="codeSnippetWrapper"> <div style="border-bottom-style: none; text-align: left; padding-bottom: 0px; line-height: 12pt; border-right-style: none; background-color: #f4f4f4; padding-left: 0px; width: 100%; padding-right: 0px; font-family: 'Courier New',courier,monospace; direction: ltr; border-top-style: none; color: black; font-size: 10pt; border-left-style: none; overflow: visible; padding-top: 0px" id="codeSnippet">
<pre style="border-bottom-style: none; text-align: left; padding-bottom: 0px; line-height: 12pt; border-right-style: none; background-color: white; margin: 0em; padding-left: 0px; width: 100%; padding-right: 0px; font-family: 'Courier New',monospace; direction: ltr; border-top-style: none; color: black; font-size: 10pt; border-left-style: none; overflow: visible; padding-top: 0px">--异常处理

 
 others 
);
;
自定义异常

; --自定义的异常myerr
;
 (age < 0) 
自定义异常

 || age);     
 ;
 ex_custom_invaild_age 
);
程序异常
        
);
 || age);
;
     
;
自定义异常关联，
       
 dept (10,,);
       
 ex_custom_error 
);
 sal  vSal  emp;

 too_many_rows 
);
 others 
);

 sal  vSal  emp  empno = 1;

 no_data_found 
);
 others 
);
  errorLog (
 ,

  seq_errorLog_id   1 increment  1;
  dept  deptno = vDeptno;
;
;
sqlCODE;
sqlERRM;
 errorLog (seq_errorLog_id.nextval,vErrCode,vErrMsg,sysdate);
;
 *  errorLog;