Oracle DBMS_SERVICE_ERR Demos

Oracle DBMS_SERVICE_ERR Version 12.1.0.1

General Information

Library Note

Morgan's Library Page Footer

The Library is currently in the process of being upgraded from Oracle Database Version 11.2.0.3 to 12.1.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.

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

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;

Undocumented

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

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

Related Topics

DBMS_SYSTEM_CONST

DBMS_SYSTEM_PRVT

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-2013 Daniel A. Morgan All Rights Reserved