Oracle | MGWI

Oracle MGWI_REG 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 Messaging Gateway Registration

AUTHID DEFINER

Dependencies

DBA_OBJECTS

DBMS_REGISTRY

Documented No

First Available Not known

Security Model Owned by SYS with no privileges granted

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

SQL> @?/mgw/admin/mgwireg.plb

      

      SP2-0808: Package created with compilation warnings

      

      Package body created.

      SQL> sho err

      No errors.

Subprograms

CHECK_OBJECTS	CHECK_SCHEDULER	VALIDATE_MGW
CHECK_QUEUES

CHECK_OBJECTS

Undocumented mgwi_reg.check_objects RETURN BINARY_INTEGER;

SELECT mgwi_reg.check_objects

FROM dual;

      

      CHECK_OBJECTS

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

                  1

CHECK_QUEUES

Undocumented mgwi_reg.check_queues RETURN BINARY_INTEGER;

SELECT mgwi_reg.check_queues

      FROM dual;

      

      CHECK_QUEUES

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

                 1

CHECK_SCHEDULER

Undocumented mgwi_reg.check_scheduler RETURN BINARY_INTEGER;

SELECT mgwi_reg.check_scheduler

      FROM dual;

      

      CHECK_SCHEDULER

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

                    1

VALIDATE_MGW

Undocumented mgwi_reg.validate_mgw;

exec mgwi_reg.validate_mgw;

      

      PL/SQL procedure successfully completed.