Oracle | DBMS_LOGREP_UTIL

Oracle DBMS_LOGREP_UTIL_INVOK Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Internal support for log file replication utilities

AUTHID CURRENT_USER

Dependencies

DBMS_APPLY_ADM	DBMS_LOGREP_UTIL	DBMS_STREAMS_ADM_IVK
DBMS_APPLY_ADM_INTERNAL	DBMS_PRIV_CAPTURE	DBMS_STREAMS_ADM_UTL
DBMS_APPLY_ADM_IVK	DBMS_PROPAGATION_INTERNAL	DBMS_STREAMS_ADM_UTL_INVOK
DBMS_CAPTURE_ADM	DBMS_RECO_SCRIPT_INVOK	DBMS_STREAMS_MT
DBMS_CAPTURE_ADM_INTERNAL	DBMS_SHARED_CAPTURE_ADM	DBMS_XSTREAM_ADM
DBMS_CAPTURE_ADM_IVK	DBMS_SHARED_CAPTURE_INTERNAL	DBMS_XSTREAM_ADM_UTL
DBMS_GSM_DBADMIN	DBMS_STREAMS_ADM	DBMS_XSTREAM_UTL_IVK
DBMS_LOGREP_LIB

Documented No

First Available 12.2

Security Model Owned by SYS with no privileges granted.

Source {ORACLE_HOME}/rdbms/admin/prvthlut.plb

Subprograms

CHECK_BECOME_USER_PRIVILEGE	CHECK_PDB_ACCESS	GET_OBJECT_NAME
CHECK_DV_STREAMS_ADMIN

CHECK_BECOME_USER_PRIVILEGE

Undocumented dbms_logrep_util_invok.check_become_user_privilege(cannon_user_name IN VARCHAR2);

exec dbms_logrep_util_invok.check_become_user_privilege('UWCLASS');

      

      PL/SQL procedure successfully completed.

CHECK_DV_STREAMS_ADMIN

Undocumented dbms_logrep_util_invok.check_dv_streams_admin(user_name IN VARCHAR2) RETURN BOOLEAN;

BEGIN

        IF dbms_logrep_util_invok.check_dv_streams_admin('UWCLASS') THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      T

      

      PL/SQL procedure successfully completed.

CHECK_PDB_ACCESS

Not sure what it is supposed to do but it doesn't seem to do anything even if you give it an invalid PDB name or a name that could never be valid as show at right. dbms_logrep_util_invok.check_pdb_access(container_in VARCHAR2);

exec dbms_logrep_util_invok.check_pdb_access('PDBDEV');

      

      PL/SQL procedure successfully completed.

      
      

      exec dbms_logrep_util_invok.check_pdb_access('PDB DEV');

      

      PL/SQL procedure successfully completed.

GET_OBJECT_NAME

Undocumented dbms_logrep_util_invok.get_object_name( object_name IN VARCHAR2, canon_owner OUT VARCHAR2, canon_name OUT VARCHAR2, canon_schema IN VARCHAR2, allow_3X_iden IN BOOLEAN);

DECLARE

       oOwner VARCHAR2(30);

       oName  VARCHAR2(30);

      BEGIN

        dbms_logrep_util_invok.get_object_name('SALES', oOwner, oName, 'C##SH', FALSE);

        dbms_output.put_line(oOwner);

        dbms_output.put_line(oName);

      END;

      /

      C##SH

      SALES