Oracle 12cR2 DBMS_SERVICE

Oracle DBMS_SERVICE_ERR Version 12.2.0.1

General Information

Library Note

Morgan's Library Page Header

The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.2 to 12.2.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Also important ... there are rumors on the web about SPARC and Solaris being discontinued. Welcome to the age of fake news. There is absolutely not a byte of truth to these irresponsible rumors.

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

HANDLE_ERROR

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;

HANDLE_ERROR

Undocumented dbms_service_err.handle_error( errnum IN NUMBER, arg1 IN VARCHAR2);

exec dbms_service_err.handle_error(600, 'TEST');