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
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

Related Topics
Built-in Functions
Built-in Packages
Database Security
OWM_ASSERT_PKG
OWM_BULK_LOAD_PKG
OWM_CPKG_PKG
OWM_DDL_PKG
OWM_DYNSQL_ACCESS
OWM_IEXP_PKG
OWM_MIG_PKG
OWM_MP_PKG
OWM_VSCRIPT_PKG
OWM_VT_PKG
What's New In 21c
What's New In 23c

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