Database Interaction with PL/SQL: Pre-defined Exceptions - A Word About OTHERS Exception

(Page 4 of 4 )

This is a great exception which can handle almost any type of exception within PL/SQL. In general this exception is used when you are not sure about any specific error which may raise within PL/SQL block. But you are suggested to use this exception caution. This exception is very frequently used for log eventing or auditing. The following example illustrates usage of this exception.

Declare
  v_empno emp.empno%type:=&empno;
  v_ename emp.ename%type:='&ename';
  v_deptno emp.deptno%type:=&deptno;
Begin
  Insert into emp(empno,ename,deptno)
  Values (v_empno,v_ename,v_deptno);
  dbms_output.put_line('Employee Successfully Inserted');
Exception
  When OTHERS then
    dbms_output.put_line('An error occurred. Please check your values');
End ;

You should also observe from the above example that the error message is also bit generic rather than confirming to only one scenario (like previous example). It is suggested to provide a generic error message within OTHERS exception, as you may not know any specific error which may occur.

DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware.

Comments On: Database Interaction with PL/SQL: Pre-defined Exceptions

· Hello guys, this is my article on working with pre-defined exceptions in PL/SQL. You...   >>> Post your comment now!