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