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

Direct access to this package is prevented by means of an Accessible By clause.
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-2022 Daniel A. Morgan All Rights Reserved
  DBSecWorx