Oracle KUPU$UTILITIES
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 DataPump utilities
AUTHID CURRENT_USER
Data Types TYPE xml_repl_tab_t IS ....
Dependencies
DBMS_ASSERT DBMS_PLUGTS KUPU$UTILITIES_INT
DBMS_DATAPUMP DBMS_UTILITY KUPUTIL
DBMS_LOB KUPCC KUPV$FT_INT
DBMS_METADATA_INT KUPM$MCP PLITBLM
DBMS_METADATA_UTIL KUPP$PROC  
Documented No
First Available Not known
Security Model Owned by SYS with EXECUTE granted to PUBLIC

Direct access to some objects in this package is prevented by means of an Accessible By clause.
Source {ORACLE_HOME}/rdbms/admin/prvthpu.plb
Subprograms
 
BITCLR
Undocumented kupu$utilities.bitClr(
mask1 IN OUT NUMBER,
mask2 IN     NUMBER);
DECLARE
 m1 NUMBER := 24;
 m2 NUMBER := 42;
BEGIN
  kupu$utilities.bitClr(m1, m2);
  dbms_output.put_line(TO_CHAR(m1));
END;
/
16

PL/SQL procedure successfully completed.
 
BITSET
Undocumented kupu$utilities.bitSet(
mask1 IN OUT NUMBER,
mask2 IN     NUMBER);
DECLARE
 m1 NUMBER := 24;
 m2 NUMBER := 42;
BEGIN
  kupu$utilities.bitSet(m1, m2);
  dbms_output.put_line(TO_CHAR(m1));
END;
/
58

PL/SQL procedure successfully completed.
 
BITSETRET
Undocumented kupu$utilities.bitSetRet(
mask1 IN NUMBER,
mask2 IN NUMBER)
RETURN NUMBER;
DECLARE
 m1     NUMBER := 24;
 m2     NUMBER := 42;
 retVal NUMBER;
BEGIN
  retVal := kupu$utilities.bitSetRet(m1, m2);
  dbms_output.put_line(TO_CHAR(retVal));
END;
/
58

PL/SQL procedure successfully completed.
 
BITSOC
Undocumented kupu$utilities.bitSoc(
mask1 IN OUT NUMBER,
mask2 IN     NUMBER,
expr  IN     BOOLEAN);
DECLARE
 m1     NUMBER := 24;
 m2     NUMBER := 42;
BEGIN
  kupu$utilities.bitSoc(m1, m2, TRUE);
  dbms_output.put_line(TO_CHAR(m1));
END;
/
58

PL/SQL procedure successfully completed.

DECLARE
 m1     NUMBER := 24;
 m2     NUMBER := 42;
BEGIN
  kupu$utilities.bitSoc(m1, m2, FALSE);
  dbms_output.put_line(TO_CHAR(m1));
END;
/
16

PL/SQL procedure successfully completed.
 
BITTST
Undocumented kupu$utilities.bitTst(
mask1 IN NUMBER,
mask2 IN NUMBER)
RETURN BOOLEAN;
DECLARE
 m1 NUMBER := 24;
 m2 NUMBER := 42;
BEGIN
  IF kupu$utilities.bitTst(m1, m2) THEN
    dbms_output.put_line('T');
  ELSE
  dbms_output.put_line('F');
  END IF;
END;
/
F

PL/SQL procedure successfully completed.
 
BITTSTANY
Undocumented kupu$utilities.bitTstAny(
mask1 IN NUMBER,
mask2 IN NUMBER)
RETURN BOOLEAN;
DECLARE
 m1 NUMBER := 24;
 m2 NUMBER := 42;
BEGIN
  IF kupu$utilities.bitTstAny(m1, m2) THEN
    dbms_output.put_line('T');
  ELSE
  dbms_output.put_line('F');
  END IF;
END;
/
T

PL/SQL procedure successfully completed.
 
BOOLTOINT
Returns "trueval" if the Boolean is TRUE, else always returns 0 for FALSE kupu$utilities.boolToInt(
boolval IN BOOLEAN,
trueval IN NUMBER)
RETURN BINARY_INTEGER;
DECLARE
 retVal BINARY_INTEGER;
BEGIN
  retVal := kupu$utilities.boolToInt(, 42);
  dbms_output.put_line(retVal);
END;
/
42

PL/SQL procedure successfully completed.
 
BOOLTOSTR
Converts a Boolean into its string representation kupu$utilities.boolToStr(boolval IN BOOLEAN) RETURN VARCHAR2;
DECLARE
 retVal dbms_id;
BEGIN
  retVal := kupu$utilities.boolToStr(FALSE);
  dbms_output.put_line(retVal);
END;
/
FALSE

PL/SQL procedure successfully completed.
 
CHECK_ENCRYPTION_WALLET
Undocumented kupu$utilities.check_encryption_wallet;
exec kupu$utilities.check_encryption_wallet;

PL/SQL procedure successfully completed.
 
CHECK_IF_SHARDED_DB
Undocumented kupu$utilities.check_if_sharded_db RETURN NUMBER;
SELECT kupu$utilities.check_if_sharded_db
FROM dual;

KUPU$UTILITIES.CHECK_IF_SHARDED_DB
--------------------------------------------------
 
 
CHECK_TBS_FOR_TDECOL_TABS
Presumably returns 1 if a tablespace contains tables encrypted with TDE, else 0 but unable to demonstrate that kupu$utilities.check_tbs_for_tdecol_tabs(tbs IN VARCHAR2) RETURN NUMBER;
SELECT kupu$utilities.check_tbs_for_tdecol_tabs('SYSTEM')
FROM dual;

KUPU$UTILITIES.CHECK_TBS_FOR_TDECOL_TABS('SYSTEM')
--------------------------------------------------
 
 
DEBUG
Undocumented kupu$utilities.debug(str IN VARCHAR2);
exec kupu$utilities.debug('ZZYZX');

PL/SQL procedure successfully completed.
 
FORMAT_ERROR_STACK
Undocumented

Likely protected with an Accessible By clause
kupu$utilities.format_error_stack RETURN VARCHAR2;
SELECT kupu$utilities.format_error_stack
FROM dual;
SELECT kupu$utilities.format_error_stack
*
ERROR at line 1:
ORA-06553: PLS-904: insufficient privilege to access object FORMAT_ERROR_STACK
 
GET_DB_VERSION
Undocumented kupu$utilities.get_db_version(
dblink  IN  VARCHAR2,
version OUT VARCHAR2,
compat  OUT VARCHAR2);
TBD
 
GET_NLS_ALTER_SESSION
Undocumented kupu$utilities.get_nls_alter_session RETURN VARCHAR2;
SELECT kupu$utilities.get_nls_alter_session
FROM dual;

GET_NLS_ALTER_SESSION
------------------------------
 
 
GET_PLATFORM_NAME
Undocumented kupu$utilities.get_platform_name RETURN VARCHAR2;
SELECT kupu$utilities.get_platform_name
FROM dual;

GET_PLATFORM_NAME
------------------------------
 
 
GET_REMOTE_DBLINK_USER
Undocumented

Possibly protected by an Accessible By clause
kupu$utilities.get_remote_dblink_user(link_name IN VARCHAR2) RETURN VARCHAR2;
SELECT kupu$utilities.get_tstz_version('CN01.ORACLEVCN.COM')
FROM dual;
SELECT kupu$utilities.get_tstz_version('CN01.ORACLEVCN.COM')
*
ERROR at line 1:
ORA-06553: PLS-904: insufficient privilege to access object GET_TSTZ_VERSION
 
GET_TSTZ_VERSION
Undocumented

Possibly protected by an Accessible By clause
kupu$utilities.get_tstz_version(remote_link IN VARCHAR2) RETURN NUMBER;
SELECT kupu$utilities.get_tstz_version('CN01.ORACLEVCN.COM')
FROM dual;
SELECT kupu$utilities.get_tstz_version('CN01.ORACLEVCN.COM')
*
ERROR at line 1:
ORA-06553: PLS-904: insufficient privilege to access object GET_TSTZ_VERSION
 
REPLACE_XML_VALUES
Undocumented kupu$utilities.replace_xml_values(
xml_repl_tab IN sys.kupu$utilities.xml_repl_tab_t,
xml_clob     IN CLOB)
RETURN CLOB;
TBD
 
UPDATEFEATURETABLE
Undocumented

Overload 1
kupu$utilities.updateFeatureTable(utility_name IN VARCHAR2);
TBD
Overload 2 kupu$utilities.updateFeatureTable(
utility_name IN VARCHAR2,
feature_info IN sys.kupu$utilities.feature_info_t);
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
KUPU$UTILITIES_INT
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-2021 Daniel A. Morgan All Rights Reserved
  DBSecWorx