Oracle Advanced Queuing Series: 1. Create Message Type, AQ Table and Queue

Welcome to the first part of the series “Oracle Advanced Queuing”.

We start with the basic elements of Oracle Advanced Queuing:
the message type, the queue table and finally the queue.

  1. Create a Type for your messages:
    CREATE TYPE my_queue_typ  AS OBJECT(message_text VARCHAR2(4000));
  2. Create an AQ Table based on your type:
    EXEC DBMS_AQADM.CREATE_QUEUE_TABLE('my_queue_table', 'my_queue_type');
  3. Create a Message Queue with your table:
    EXEC DBMS_AQADM.CREATE_QUEUE('my_queue', 'my_queue_table');
  4. Start the queue:
    EXEC DBMS_AQADM.START_QUEUE('my_queue');

I will speak at the “DOAG 2013 Konferenz + Ausstellung”

I will be on the “DOAG 2013 Konferenz + Ausstellung” in Nürnberg (Nuremberg), Germany from November 19th to 21th.

I will speak at November 21th, at 3 pm at room 2 “Seoul”:

Lösen Sie (fast) alle Ihre Probleme mit Oracle Advanced Queuing

(English: “Solving (almost) all your IT problems with Oracle Advanced Queuing”)

The DOAG is the largest German Oracle user group with over 5000 members.
This years conference offers over 400 speeches from well known Oracle experts like:

2013-Konferenz-Banner_Speaker-180x150_hoch