Introdução 

 SQL Scripts 

 Packages 
 pkg_nkw_exc 
 pkg_nkw_env 
 pkg_nkw_rpl 
 pkg_nkw_std 
 pkg_nkw_app 
 pkg_nkw_spm 
 pkg_nkw_hfs 
 pkg_nkw_sdv 
 pkg_nkw_sys 
 pkg_nkw_obj 
 pkg_nkw_grv 
 pkg_nkw_usr 
 pkg_nkw_cmm 
 pkg_nkw_hlp 
 pkg_nkw_dvp 
 pkg_nkw_dnt_std 
 pkg_nkw_dnt_dvies 
 pkg_nkw_dnt_ccvies 
 pkg_nkw_dnt_logies 
 pkg_nkw_dnt_eppc 
 pkg_nkw_dnt_eapb 
 pkg_nkw_dnt_drmies 
 pkg_nkw_dnt 
 pkg_nkw_drm 
 pkg_nkw_oim 
 pkg_nkw_aud 
 pkg_nkw_dpl 
 pkg_nkw_srw 

 Packages Body 

 Forms 6i 

 Reports 6i 

Linux

 Downloads 
PKG_NKW_EXC.SPS
Source Package Specification
Definições e log de exceções.
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;
© 2017 DataPRO Developers