Oracle | AA

Oracle OWM_DML_PKG 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 Oracle Wallet Manager (OWM) Utilities

AUTHID DEFINER

Dependencies

LT	WM$EV_I_TRIG	WM$VET_I_TRIG
LTADM	WM$HT_I_TRIG	WM$VET_U_TRIG
LTUTIL	WM$MGWT_I_TRIG	WM$VTH_I_TRIG
UD_TRIGS	WM$MPWT_I_TRIG	WM$VTH_U_TRIG
WM$CP_I_TRIG	WM$RT_I_TRIG	WM$WPT_D_TRIG
WM$CP_U_TRIG	WM$RWT_I_TRIG	WM$WPT_I_TRIG
WM$CT_I_TRIG	WM$SAV_I_TRIG	WM$WPT_U_TRIG
WM$CT_U_TRIG	WM$UDP_I_TRIG	WM$WST_I_TRIG
WM$EI_I_TRIG	WM$UD_U_TRIG	WM$WT_I_TRIG
WM$EI_U_TRIG	WM$UI_I_TRIG	WM$WT_U_TRIG

First Available 12.1

Security Model Owned by WMSYS with no privileges granted

Direct access to this package is prevented by means of an Accessible By clause.

Source {ORACLE_HOME}/rdbms/admin/owmwdmls.plb
{ORACLE_HOME}/rdbms/admin/owmwdmlb.plb

Subprograms

WM$COLUMN_PROPS$F	WM$MP_PARENT_WORKSPACES_T$F	WM$VERSIONED_TABLES$F
WM$CONSTRAINTS_TABLE$F	WM$RESOLVE_WORKSPACES_TABLE$F	WM$VT_ERRORS_TABLE$F
WM$ENV_VARS$F	WM$RIC_TABLE$F	WM$WORKSPACES_TABLE$F
WM$EVENTS_INFO$F	WM$SYSPARAM_ALL_VALUES$F	WM$WORKSPACE_PRIV_TABLE$F
WM$HINT_TABLE$F	WM$UDTRIG_DISPATCH_PROCS$F	WM$WORKSPACE_SAVEPOINTS_T$F
WM$MP_GRAPH_WORKSPACES_TABLE$F	WM$UDTRIG_INFO$F

WM$COLUMN_PROPS$F

Undocumented owm_dml_pkg.wm$column_props$f(identity_type IN VARCHAR2) RETURN NUMBER;

TBD

WM$CONSTRAINTS_TABLE$F

Undocumented owm_dml_pkg.wm$constraints_table$f( constraint_type IN VARCHAR2, status IN VARCHAR2, index_type IN VARCHAR2) RETURN NUMBER;

TBD

WM$ENV_VARS$F

Undocumented owm_dml_pkg.wm$env_vars$f(hidden_v IN NUMBER) RETURN NUMBER;

conn wmsys

      Password: 

      

      SELECT wmsys.owm_dml_pkg.wm$env_vars$f(1)

      FROM dual;

      SELECT wmsys.owm_dml_pkg.wm$env_vars$f(1)

      *

      ERROR at line 1:

      ORA-06553: PLS-904: insufficient privilege to access object OWM_DML_PKG

WM$EVENTS_INFO$F

Undocumented owm_dml_pkg.wm$events_info$f(capture IN VARCHAR2) RETURN NUMBER;

TBD

WM$HINT_TABLE$F

Undocumented owm_dml_pkg.wm$hint_table$f(isdefault IN NUMBER) RETURN NUMBER;

conn wmsys

      Password: 

      

      SELECT wmsys.owm_dml_pkg.wm$hint_table$f(1)

      FROM dual;

      SELECT wmsys.owm_dml_pkg.wm$hint_table$f(1)

      *

      ERROR at line 1:

      ORA-06553: PLS-904: insufficient privilege to access object OWM_DML_PKG

WM$MP_GRAPH_WORKSPACES_TABLE$F

Undocumented owm_dml_pkg.wm$mp_graph_worksapces_table$f(mp_graph_flag IN VARCHAR2) RETURN NUMBER;

TBD

WM$MP_PARENT_WORKSPACES_T$F

Undocumented owm_dml_pkg.wm$mp_parent_worksapces_t$f( isrefreshed IN NUMBER, parent_flag IN VARCHAR2) RETURN NUMBER;

TBD

WM$RESOLVE_WORKSPACES_TABLE$F

Undocumented owm_dml_pkg.wm$resolve_workspaces_table$f(oldfreezemode IN VARCHAR2) RETURN NUMBER;

TBD

WM$RIC_TABLE$F

Undocumented owm_dml_pkg.wm$ric_table$f( my_mode IN VARCHAR2, status IN VARCHAR2) RETURN NUMBER;

TBD

WM$SYSPARAM_ALL_VALUES$F

Undocumented owm_dml_pkg.wm$sysparam_all_values$f( isdefault IN VARCHAR2, hidden_v IN NUMBER) RETURN NUMBER;

TBD

WM$UDTRIG_DISPATCH_PROCS$F

Undocumented owm_dml_pkg.wm$udtrig_dispatch_proc$f(trig_flag IN NUMBER) RETURN NUMBER;

TBD

WM$UDTRIG_INFO$F

Undocumented owm_dml_pkg.wm$udtrig_info$f( trig_flag IN NUMBER, status IN VARCHAR2, internal_type IN VARCHAR2, event_flag IN NUMBER) RETURN NUMBER;

TBD

WM$VERSIONED_TABLES$F

Undocumented owm_dml_pkg.wm$versioned_tables$f( disabling_ver IN VARCHAR2, hist IN VARCHAR2, validtime IN NUMBER, bl_savepoint IN VARCHAR2, bl_check_for_duplicates IN VARCHAR2, bl_single_transaction IN VARCHAR2, identity_type IN VARCHAR2) RETURN NUMBER;

TBD

WM$VT_ERRORS_TABLE$F

Undocumented owm_dml_pkg.wm$vt_errors_table$f(status IN VARCHAR2) RETURN NUMBER;

TBD

WM$WORKSPACES_TABLE$F

Undocumented owm_dml_pkg.wm$workspaces_table$f( freeze_status IN VARCHAR2, freeze_mode IN VARCHAR2, wm_lockmode IN VARCHAR2, isrefreshed IN NUMBER, session_duration IN NUMBER, cr_status IN VARCHAR2, keep IN NUMBER) RETURN NUMBER;

TBD

WM$WORKSPACE_PRIV_TABLE$F

Undocumented owm_dml_pkg.wm$workspace_priv_table$f( priv IN VARCHAR2, admin IN NUMBER) RETURN NUMBER;

TBD

WM$WORKSPACE_SAVEPOINTS_T$F

Undocumented owm_dml_pkg.wm$workspace_savepoints_t$f(is_implicit IN NUMBER) RETURN NUMBER;

TBD