Oracle OWM_VSCRIPT_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 Workspace Manager utilities
AUTHID CURRENT_USER
Dependencies
ALL_USERS DBA_SYS_PRIVS LTRIC
CDB_OBJECTS DBA_TABLES LTUTIL
CDEF$ DBA_TAB_COLS LT_CTX_PKG
CON$ DBA_TRIGGERS LT_EXPORT_PKG
DBA_CONSTRAINTS DBA_TRIGGERS OBJ$
DBA_OBJECTS DBMS_DATAPUMP OWM_ASSERT_PKG
DBA_OPERATORS DBMS_REGISTRY OWM_DDL_PKG
DBA_QUEUES DBMS_STANDARD PLITBLM
DBA_ROLES DBMS_UTILITY V$OPTION
DBA_ROLE_PRIVS LT V$PARAMETER
DBA_SEQUENCES LTI WM_DDL_UTIL
DBA_SYNONYMS    
Documented No
First Available Not known
Security Model Owned by WMSYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/owmvpkgs.plb
{ORACLE_HOME}/rdbms/admin/owmvpkgb.plb
Subprograms
 
STARTQUEUE
Undocumented owm_vscript_pkg.startQueue;
exec wmsys.owm_vscript_pkg.startQueue;
BEGIN wmsys.owm_vscript_pkg.startQueue; END;
      *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00904: insufficient privilege to access object STARTQUEUE
 
STOPQUEUE
Undocumented owm_vscript_pkg.stopQueue(dropqueueandtable IN BOOLEAN);
exec wmsys.owm_vscript_pkg.stopQueue(FALSE);
BEGIN wmsys.owm_vscript_pkg.stopQueue(FALSE); END;
      *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00904: insufficient privilege to access object STOPQUEUE
 
UPGRADEOWM
Upgrade Workspace Manager owm_vscript_pkg.upgradeOWM(
owm_version IN VARCHAR2,
tab_prefix  IN VARCHAR2);
TBD
 
WM$ADDRECORD
Undocumented owm_vscript_pkg.wm$addRecord(
col1    IN VARCHAR2,
col2    IN VARCHAR2,
col3    IN VARCHAR2,
col4    IN VARCHAR2,
col5    IN VARCHAR2,
ctype   IN VARCHAR2,
firste  IN BOOLEAN);
TBD
 
WM$CHECKEXISTINGRECORD
Undocumented owm_vscript_pkg.wm$checkExistingRecord(
col1_v IN VARCHAR2,
col2_v IN VARCHAR2,
col3_v IN VARCHAR2,
col4_v IN VARCHAR2,
col5   IN VARCHAR2,
common IN VARCHAR2,
ctype  IN VARCHAR2);
TBD
 
WM$CONVERTVERSIONSTR
Undocumented

Appears to be protected by an Accessible By clause
owm_vscript_pkg.wm$convertVersionStr(version_str IN VARCHAR2) RETURN VARCHAR2;
SELECT wmsys.owm_vscript_pkg.wm$convertVersionStr('21.3')
FROM dual;
SELECT wmsys.owm_vscript_pkg.wm$convertVersionStr('21.3')
       *
ERROR at line 1:
ORA-06553: PLS-904: insufficient privilege to access object WM$CONVERTVERSIONSTR
 
WM$EXECRECORDS
Undocumented owm_vscript_pkg.wm$execRecords RETURN CLOB;
SELECT wmsys.owm_vscript_pkg.wm$execRecords
FROM dual;

WM$EXECRECORDS
--------------------------------------------------------------------------------
declare
        procedure revokePriv(sqlstr varchar2) is
        begin
          execute immediate sqlstr;
        end;

        procedure grantPriv(sqlstr varchar2) is
        begin
          execute immediate sqlstr;
        end;
        begin
          null;
end;
 
WM$GETDBPARAMETER
Undocumented owm_vscript_pkg.wm$getDBParameter(param_name IN VARCHAR2) RETURN VARCHAR2;
TBD
 
WM$HASCOLUMN
Returns TRUE if the identified table column exists, else FALSE owm_vscript_pkg.wm$hasColumn(
tab_name IN VARCHAR2,
colname  IN VARCHAR2,
schema   IN VARCHAR2)
RETURN BOOLEAN;
BEGIN
  IF wmsys.owm_vscript_pkg.wm$hasColumn('T', 'TESTCOL', 'C##UWCLASS') THEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
  END IF;
END;
/
T

PL/SQL procedure successfully completed.
 
WM$INSTALLPATCH
Apply Workspace Manager patch owm_vscript_pkg.wm$installPatch;
exec wmsys.owm_vscript_pkg.wm$installPatch;

PL/SQL procedure successfully completed.
 
WM$OBJECTEXISTS
Returns TRUE if the identified object exists, else FALSE owm_vscript_pkg.wm$objectExists(
obj_name  IN VARCHAR2,
obj_owner IN VARCHAR2,
obj_type  IN VARCHAR2)
RETURN BOOLEAN;
BEGIN
  IF wmsys.owm_vscript_pkg.wm$objectExists('T', 'C##UWCLASS', 'TABLE') THEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
  END IF;
END;
/
T

PL/SQL procedure successfully completed.
 
WM$UTLRP
Undocumented but likely recompile invalid objects (similar to UTL_RECOMP) owm_vscript_pkg.wm$utlrp;
exec wmsys.owm_vscript_pkg.wm$utlrp;

PL/SQL procedure successfully completed.

Related Topics
Built-in Functions
Built-in Packages
Database Security
OWM_ASSERT_PKG
OWM_BULK_LOAD_PKG
OWM_CPKG_PKG
OWM_DDL_PKG
OWM_DML_PKG
OWM_DYNSQL_ACCESS
OWM_IEXP_PKG
OWM_MIG_PKG
OWM_MP_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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx