CodeListing 2: Error handling package specification

CREATE OR REPLACE PACKAGE errpkg
IS
   PROCEDURE raise (
      err_in IN INTEGER := SQLCODE
    , msg_in IN VARCHAR2 := NULL
   );

   PROCEDURE record_and_stop (
      err_in IN INTEGER := SQLCODE
    , msg_in IN VARCHAR2 := NULL
   );

   PROCEDURE record_and_continue (
      err_in IN INTEGER := SQLCODE
    , msg_in IN VARCHAR2 := NULL
   );

   FUNCTION errtext (err_in IN INTEGER := SQLCODE)
      RETURN VARCHAR2;
END errpkg;
E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy