Oracle OWM_BULK_LOAD_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 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
Source {ORACLE_HOME}/rdbms/admin/owmblkls.plb
Subprograms
 
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

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