Oracle DBMS_SERVICE_ERR
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose Undocumented
AUTHID DEFINER
Dependencies
DBMS_SERVICE DBMS_SERVICE_LIB DBMS_SYS_ERROR
DBMS_SERVICE_CONST DBMS_SERVICE_PRVT  
Documented No
First Available 12.1.0
Security Model Owned by SYS with EXECUTE granted to the DBA role
Source {ORACLE_HOME}/rdbms/admin/prvtsrv.plb
Subprograms
 
FOLD_KSWS_ERROR
Undocumented dbms_service_err.fold_ksws_error(ksws_err IN NUMBER) RETURN NUMBER;
SELECT dbms_service_err.fold_ksws_error(00600)
FROM dual;

DBMS_SERVICE_ERR.FOLD_KSWS_ERROR(00600)
---------------------------------------
-44309
 
HANDLE_ERROR
Undocumented

An ORA-00600, by any other name, smells as bitter
dbms_service_err.handle_error(
errnum IN NUMBER,
arg1   IN VARCHAR2);
exec dbms_service_err.handle_error(44316, 'err_invalid_argument');
BEGIN dbms_service_err.handle_error(44316, 'err_invalid_argument'); END;
*
ERROR at line 1:
ORA-44309: unknown failure
ORA-06512: at "SYS.DBMS_SERVICE_ERR", line 36
ORA-06512: at line 1

Related Topics
Built-in Functions
Built-in Packages
DBMS_SYSTEM
DBMS_SYSTEM_CONST
DBMS_SYSTEM_PRVT
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx