Oracle | WM

Oracle WM_ERROR Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose WMSYS Error Handler

AUTHID DEFINER

Dependencies

DBMS_STANDARD	LTRIC	OWM_IEXP_PKG
LT	LTUTIL	OWM_MIG_PKG
LTADM	LT_CTX_PKG	OWM_MP_PKG
LTAQ	LT_EXPORT_PKG	PLITBLM
LTDDL	OWM_BULK_LOAD_PKG	UD_TRIGS
LTI	OWM_DDL_PKG	WM_DDL_UTIL
LTPRIV	OWM_DYNSQL_ACCESS

Documented No

Exceptions

Error Code	Reason
ORA-20383	Workspace Manager must first be uninstalled from each pdb prior to uninstalling from CDB$ROOT

First Available Not known

Security Model Owned by WMSYS with no privileges granted.

Source {ORACLE_HOME}/rdbms/admin/owmerrs.plb

Subprograms

GETERRORSTR

RAISEERROR

GETERRORSTR

Returns error code for WMSYS in the range of -20001 to -20400 wm_error.geterrorstr(error_no IN NUMBER) RETURN VARCHAR2;

SQL> SELECT wmsys.wm_error.geterrorstr(-20001)

        2* FROM dual;

      

      WMSYS.WM_ERROR.GETERRORSTR(-20001)

      ---------------------------------------------------------------------------------

      RAISE_APPLICATION_ERROR(-20001, 'name of column '%s' has more than %s characters')

RAISEERROR

Raises the associated Workspace Manager error

Overload 1 wm_error.raiseerror(error_no IN NUMBER);

exec wmsys.wm_error.raiseerror(wmsys.lt.wm_error_383_no);

      BEGIN wmsys.wm_error.raiseerror(wmsys.lt.wm_error_383_no); 
      END;

      *

      ERROR at line 1:

      ORA-20383: Workspace Manager must first be uninstalled from each pdb prior to uninstalling from CDB$ROOT

      ORA-06512: at "WMSYS.WM_ERROR", line 449

      ORA-06512: at "WMSYS.WM_ERROR", line 456

      ORA-06512: at line 1

Overload 2 wm_error.raiseerror( error_no IN NUMBER, arg1 IN VARCHAR2);

TBD

Overload 3 wm_error.raiseerror( error_no IN NUMBER, arg1 IN VARCHAR2, arg2 IN VARCHAR2);

TBD

Overload 4 wm_error.raiseerror( error_no IN NUMBER, arg1 IN VARCHAR2, arg2 IN VARCHAR2, arg3 IN VARCHAR2);

TBD

Overload 5 wm_error.raiseerror( error_no IN NUMBER, arg1 IN VARCHAR2, arg2 IN VARCHAR2, arg3 IN VARCHAR2, arg4 IN VARCHAR2);

TBD

Overload 6 wm_error.raiseerror( error_no IN NUMBER, arg1 IN VARCHAR2, arg2 IN VARCHAR2, arg3 IN VARCHAR2, arg4 IN VARCHAR2, arg5 IN VARCHAR2);

TBD