Oracle | OWM_BULK_LOAD

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

DBA_CONSTRAINTS	LTADM	WM$DBA_TAB_COLS
DBA_CONS_COLUMNS	LTI	WM$MODIFIED_TABLES
DBA_IND_COLUMNS	LTRIC	WM$RIC_TABLE
DBA_TABLES	LTUTIL	WM$versionED_TABLES
DBA_TRIGGERS	LT_CTX_PKG	WM$versionED_TABLES$D
DBMS_LOB	OWM_ASSERT_PKG	WM$version_HIERARCHY_TABLE
DBMS_LOCK	OWM_DDL_PKG	WM$VT_errorS_TABLE
DBMS_UTILITY	OWM_DYNSQL_ACCESS	WM$workspaceS_TABLE
LT	WM$CONSTRAINTS_TABLE	WM_error

Documented No

First Available Not known

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/owmblkls.plb

Subprograms

BEGINBULKLOADING	EXISTSTABLE	purgeTABLE
CHECKFORBULKLOADING	FIXOWMCOLSWHIST	ROLLBACKBULKLOADING
ENDBULKLOADING	ISBEINGBULKLOADED	SETLTLOCKINFO

BEGINBULKLOADING

Undocumented owm_bulk_load_pkg.beginBulkLoading( table_owner_var IN VARCHAR2, table_name_var IN VARCHAR2, workspace IN VARCHAR2, savepoint_name IN VARCHAR2, check_for_duplicates IN BOOLEAN, ignore_last_error IN BOOLEAN, single_transaction IN BOOLEAN);

TBD

CHECKFORBULKLOADING

Undocumented

Protected by an ACCESSIBLE BY clause owm_bulk_load_pkg.checkForBulkLoading(workspace_var IN VARCHAR2);

exec wmsys.owm_bulk_load_pkg.checkForBulkLoading('UW_WS');

      BEGIN 
      wmsys.owm_bulk_load_pkg.checkForBulkLoading('UW_WS'); END;

      *

      ERROR at line 1:

      ORA-06550: line 1, column 7:

      PLS-00904: insufficient privilege to access object OWM_BULK_LOAD_PKG

      ORA-06550: line 1, column 7:

      PL/SQL: Statement ignored

ENDBULKLOADING

Undocumented owm_bulk_load_pkg.endBulkLoading( table_owner_var IN VARCHAR2, table_name_var IN VARCHAR2, user_name_var IN VARCHAR2, discards_table_owner IN VARCHAR2, discards_table_name IN VARCHAR2, enforceucflag IN BOOLEAN, enforcericflag IN BOOLEAN, ignore_last_error IN BOOLEAN);

TBD

EXISTSTABLE

Returns TRUE if a table exists, else FALSE

Protected by an ACCESSIBLE BY clause owm_bulk_load_pkg.existsTable( towner IN VARCHAR2, tabname IN VARCHAR2) RETURN BOOLEAN;

exec wmsys.owm_bulk_load_pkg.existsTable(USER, 
      'TAB$');

      BEGIN wmsys.owm_bulk_load_pkg.existsTable(USER, 
      'TAB$'); END;

      *

      ERROR at line 1:

      ORA-06550: line 1, column 7:

      PLS-00904: insufficient privilege to access object OWM_BULK_LOAD_PKG

      ORA-06550: line 1, column 7:

      PL/SQL: Statement ignored

FIXOWMCOLSWHIST

Undocumented owm_bulk_load_pkg.fixOWMColSWHist( table_owner_var IN VARCHAR2, table_name_var IN VARCHAR2, user_name_var IN VARCHAR2, workspace_var IN VARCHAR2, version_var IN NUMBER, bulkloadversionvar IN NUMBER, updateonlydls IN BOOLEAN);

TBD

ISBEINGBULKLOADED

Undocumented

Protected by an ACCESSIBLE BY clause owm_bulk_load_pkg.isBeingBulkLoaded( table_owner_var IN VARCHAR2, table_name_var IN VARCHAR2) RETURN BOOLEAN;

BEGIN

  IF wmsys.owm_bulk_load_pkg.isBeingBulkLoaded 
      THEN

    dbms_output.put_line('T');

  ELSE

    dbms_output.put_line('F');

  END IF;

      END;

      /

       IF wmsys.owm_bulk_load_pkg.isBeingBulkLoaded 
      THEN

      *

      ERROR at line 2:

      ORA-06550: line 2, column 6:

      PLS-00904: insufficient privilege to access object OWM_BULK_LOAD_PKG

      ORA-06550: line 2, column 3:

      PL/SQL: Statement ignored

purgeTABLE

Undocumented owm_bulk_load_pkg.purgeTable( table_owner_var IN VARCHAR2, table_name_var IN VARCHAR2, archive_table_owner IN VARCHAR2, archive_table_name IN VARCHAR2, where_clause IN VARCHAR2, workspace_var IN VARCHAR2, version_var IN NUMBER, instant IN TIMESTAMP WITH TIME ZONE, purgeafter IN BOOLEAN);

TBD

ROLLBACKBULKLOADING

Undocumented

Protected by an ACCESSIBLE BY clause owm_bulk_load_pkg.rollbackBulkLoading( table_owner_var IN VARCHAR2, table_name_var IN VARCHAR2, ignore_last_error IN BOOLEAN);

exec wmsys.owm_bulk_load_pkg.rollbackBulkLoading('SYS', 'TAB$', FALSE);

      BEGIN 
      wmsys.owm_bulk_load_pkg.rollbackBulkLoading('SYS', 'TAB$', FALSE); END;

      *

      ERROR at line 1:

      ORA-06550: line 1, column 7:

      PLS-00904: insufficient privilege to access object OWM_BULK_LOAD_PKG

      ORA-06550: line 1, column 7:

      PL/SQL: Statement ignored

SETLTLOCKINFO

Undocumented owm_bulk_load_pkg.setLTLockInfo(wm_ltlock IN VARCHAR2) RETURN VARCHAR2;

TBD