Verifying a Queue Type

Figure 9-25 Use Case Diagram: Verify a Queue Type

Text description of the illustration adq09qad30.gif

Purpose

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.

Usage Notes

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.

Note: The sys.aq$_message_types table can have multiple entries for the same source queue, destination queue, and dblink, but with different transformations.

Syntax

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:

• PL/SQL (DBMS_AQADM Package): Oracle9i Supplied PL/SQL Packages and Types Reference DBMS_AQADM, VERIFY_QUEUE_TYPES procedure

• Visual Basic (OO4O): There is no applicable syntax reference for this use case

• Java (JDBC): There is no applicable syntax reference for this use case

Examples

See Chapter 3, "AQ Programmatic Environments" for a list of available functions in each programmatic environment. Examples are provided in the following programmatic environments:

• PL/SQL (DBMS_AQADM): Verifying a Queue Type

• VB (OO4O): Example not provided.

• Java (JDBC): Verifying a Queue type

PL/SQL (DBMS_AQADM): Verifying a Queue Type

Note: You may need to set up the following data structures for certain examples to work: EXECUTE DBMS_AQADM.CREATE_QUEUE ( queue_name => 'aq.q2def', queue_table => 'aq.objmsgs_qtab');

/*  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;

Java (JDBC): Verifying a Queue type

Feature not available through Java API