Oracle 12cR2 DBMSZEXP

Oracle DBMSZEXP_SYSPKGGRNT Version 12.2.0.1

General Information

Library Note

Morgan's Library Page Header

Are you prepared for the release of Oracle Database 18c ... the first autonomous database? We are here at the Library. It is time for DBAs to stop fighting robots with their fingers and losing ... time to start using our intelligence and winning.

Purpose Generates the SQL for DBMS_UTILITY.EXEC_DDL_STATEMENT to grant EXECUTE on DBMS_AQADM to the AQ_ADMINISTRATOR_ROLE role

AUTHID DEFINER

Dependencies

DBMS_ASSERT

DBMS_STANDARD

DBMS_ZHELP

Documented No

First Available Not known

Security Model Owned by SYS with EXECUTE granted to EXECUTE_CATALOG_ROLE and EXP_FULL_DATABASE roles.

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

SYSTEM_INFO_EXP

Generate SQL to create grant dbmszexp_syspkggrnt( prepost IN BINARY_INTEGER, connectstring OUT VARCHAR2, version IN VARCHAR2, new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

DECLARE

       retVal  VARCHAR2(128);

       cstring VARCHAR2(128);

       nblock  PLS_INTEGER;

      BEGIN

        retVal := dbmszexp_syspkggrnt.system_info_exp(1, cstring, '12.1', nblock);

        dbms_output.put_line(retVal);

        dbms_output.put_line(cstring);

        dbms_output.put_line(TO_CHAR(nblock));

      END;

      /