create or replace package pkg_nkw_exc
timestamp '2006-07-07:10:10:10'
is
   ------------------------------------------------------------------
   -- 2006 DataPRO Developers - m@urelio
   ------------------------------------------------------------------
   -- Version: 2.0.2
   ------------------------------------------------------------------
   -- Collections, Records, Variables, Constants, Exceptions, Cursors
   ------------------------------------------------------------------
   gv_devexc    constant integer := 0;
   gv_usrexc    constant integer := 1;
   obj_locked   exception;
        pragma  exception_init(obj_locked, -54);       -- ORA-00054: resource busy and acquire with NOWAIT specified
   no_object    exception;
      pragma exception_init(no_object, -942);          -- ORA-00942: table or view does not exist
   no_syn       exception;
      pragma exception_init(no_syn, -1432);            -- ORA-01432: public synonym to be dropped does not exist
   yet_syn       exception;
      pragma exception_init(yet_syn, -1433);           -- ORA-01433: synonym to be created is already defined
   no_column    exception;
      pragma exception_init(no_object, -904);          -- ORA-00904: invalid column name
   no_role      exception;
      pragma exception_init(no_role, -1917);           -- ORA-01917: user or role name does not exist
   no_user      exception;
      pragma exception_init(no_user, -1918);           -- ORA-01918: user name does not exist
   yet_user     exception;
      pragma exception_init(yet_user, -1920);          -- ORA-01920: user name conflits with another user/function
   invalid_username  exception;
      pragma exception_init(invalid_username, -1935);  -- ORA-01935: user name conflits with another user/function
   is_connected exception;
      pragma exception_init(is_connected, -1940);      -- ORA-01940: cannot DROP a user that is currently logged in
   no_grant     exception;
      pragma exception_init(no_grant, -1952);          -- ORA-01952: system privileges not granted to name
   no_password  exception;
        pragma  exception_init(no_password, -988);     -- ORA-00988: password missing or invalid
   ------------------------------------------------------------------
   -- POP_EXCEPTION
   ------------------------------------------------------------------
   procedure pop_exception(fv_text  in varchar2,
                           fv_scope in integer := gv_devexc);
end pkg_nkw_exc;
/
show errors