Verify a Queue Type

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

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

Not applicable.

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): Oracle8i Supplied PL/SQL Packages 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): Verify a Queue Type

• VB (OO4O): Example not provided.

• Java (JDBC): Verify a Queue type

PL/SQL (DBMS_AQADM): Verify 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): Verify a Queue type

Feature not available through Java API