Oracle OWM_DML_PKG
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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

This package is protected from direct use by an ACCESSIBLE BY clause and demonstrated below.
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 19c
What's New In 20c-21c

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