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;
|