Oracle | MGWI

Oracle MGWI_REG Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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.