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 will be available on generic Linux platforms in January and soon on AIX and Windows

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