Oracle | KUPU$UTILITIES

Oracle KUPU$UTILITIES Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

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

Access to some subpograms prevented by 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;

      

      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');

      

      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;

            
      *

      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;

      

      GET_NLS_ALTER_SESSION

      ------------------------------

GET_PLATFORM_NAME

Undocumented kupu$utilities.get_platform_name RETURN VARCHAR2;

SELECT kupu$utilities.get_platform_name;

      

      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');

            
      *

      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');

            
      *

      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