Oracle | DBMS_AQ

Oracle DBMS_AQ_BQVIEW 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 Advanced Queuing payload handler for non-scalar data types

AUTHID CURRENT_USER

Dependencies

DBMS_AQ_LIB

Documented No

First Available Not Known

Security Model Owned by SYS with EXECUTE granted to GSMADMIN_INTERNAL and WMSYS

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

Subprograms

Handler for ADT AQ message payloads dbms_aq_bqview.get_adt_payload( qid IN NUMBER, msgno IN BINARY_INTEGER, dummy IN sys.standard.<ADT_1>) RETURN sys.standard.<ADT_1>;

TBD

GET_OPAQUE_PAYLOAD

Handler for OPAQUE AQ message payloads dbms_aq_bqview.get_opaque_payload( quid IN NUMBER, msgno IN BINARY_INTEGER, dummy IN XMLTYPE) RETURN XMLTYPE;

TBD

GET_RAW_PAYLOAD

Handler for RAW AQ message payloads dbms_aq_bqview.get_raw_payload( quid IN NUMBER, msgno IN BINARY_INTEGER) RETURN BLOB;

TBD