Oracle | OWM_MP

Oracle OWM_MP_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 Undocumented

AUTHID DEFINER

Dependencies

DBMS_LOB	OWM_DDL_PKG	WM$MP_GRAPH_WORKSPACES_TABLE
DUAL	OWM_DYNSQL_ACCESS	WM$MP_PARENT_WORKSPACES_TABLE
LT	PLITBLM	WM$NESTED_COLUMNS_TABLE
LTADM	WM$CONSTRAINTS_TABLE	WM$RIC_TABLE
LTI	WM$MODIFIED_TABLES	WM$VERSIONED_TABLES
LTPRIV	WM$MP_GRAPH_NEW_VERSIONS	WM$VERSION_TABLE
LTRIC	WM$MP_GRAPH_OTHER_VERSIONS	WM$VERSION_VIEW
LTUTIL	WM$MP_GRAPH_REMAINING_VERSIONS	WM$WORKSPACES_TABLE
LT_CTX_PKG	WM$MP_GRAPH_REMOVED_VERSIONS	WM_ERROR
OWM_ASSERT_PKG

Documented No

First Available Not known

Security Model Owned by WMSYS with no privileges granted

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

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

Subprograms

ADDASPARENTWORKSPACE	GETGRAPHNODES	REMOVEASPARENTWORKSPACE
CREATEIMPLICITSPINGRAPH	GETNCA	SETMPPARAMETER
EXISTSMPWORKSPACE	ISMPWORKSPACE

ADDASPARENTWORKSPACE

Undocumented owm_mp_pkg.addAsParentWorkspace( workspace IN VARCHAR2, parent_workspace IN VARCHAR2);

TBD

CREATEIMPLICITSPINGRAPH

Undocumented owm_mp_pkg.createImplicitSpinGraph( leaf_workspace IN VARCHAR2, description IN VARCHAR2)

TBD

EXISTSMPWORKSPACE

Retrns TRUE if the MP Workspace exists, else FALSE owm_mp_pkg.existsMPWorkspace RETURN BOOLEAN;

BEGIN

        IF wmsys.owm_mp_pkg.existsMPWorkspace THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

       IF wmsys.owm_mp_pkg.existsMPWorkspace THEN

      *

      ERROR at line 2:

      ORA-06550: line 2, column 6:

      PLS-00904: insufficient privilege to access object OWM_MP_PKG

      ORA-06550: line 2, column 3:

      PL/SQL: Statement ignored

GETGRAPHNODES

Undocumented

Overload 1 owm_mp_pkg.getGraphNodes( leaf_workspace IN VARCHAR2, parent_workspace_var IN VARCHAR2, node_types IN VARCHAR2) RETURN wmsys.ltutil.wm$ident_tab_bin;

TBD

Undocumented

Overload 2 owm_mp_pkg.getGraphNodes( leaf_workspace IN VARCHAR2, node_types IN VARCHAR2) RETURN wmsys.ltutil.wm$ident_tab_bin;

TBD

GETNCA

Undocumented owm_mp_pkg.getNCA( workspace1 IN VARCHAR2, workspace2 IN VARCHAR2) RETURN VARCHAR2;

TBD

ISMPWORKSPACE

Undocumented owm_mp_pkg.isMPWorkspace( mp_leaf_workspace_VAR IN VARCHAR2, parent_workspace_VAR IN VARCHAR2) RETURN BOOLEAN;

TBD

REMOVEASPARENTWORKSPACE

Remove the parent workspace for the indicated MP Leaf workspace owm_mp_pkg.removeAsParentWorkspace( mp_leaf_workspace IN VARCHAR2, parent_workspace IN VARCHAR2);

TBD

SETMPPARAMETER

Undocumented owm_mp_pkg.setMPParameter(new_value IN VARCHAR2);

TBD