Oracle | KUPU$UTILITIES

Oracle KUPU$UTILITIES 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 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