|Oracle9i Application Developer's Guide - Advanced Queuing
Release 1 (9.0.1)
Part Number A88890-02
Administrative Interface, 26 of 36
Verify that the source and destination queues have identical types. The result of the verification is stored in
sys.aq$_Message_types tables, overwriting all previous output of this command.
If the source and destination queues do not have identical types and a transformation was specified, the transformation must map the source queue type to the destination queue type.
See Chapter 3, "AQ Programmatic Environments" for a list of available functions in each programmatic environment. Use the following syntax references for each programmatic environment:
See Chapter 3, "AQ Programmatic Environments" for a list of available functions in each programmatic environment. Examples are provided in the following programmatic environments:
/* Verify if the source and destination queues have the same type. The function has the side effect of inserting/updating the entry for the source and destination queues in the dictionary table AQ$_MESSAGE_TYPES */ DECLARE rc BINARY_INTEGER; BEGIN /* Verify if the queues aquser.q1def and aquser.q2def in the local database have the same payload type */ DBMS_AQADM.VERIFY_QUEUE_TYPES( src_queue_name => 'aq.q1def', dest_queue_name => 'aq.q2def', rc => rc); DBMS_OUTPUT.PUT_LINE(rc); END;
Feature not available through Java API