How to Implement Advanced Queuing in your custom Oracle Apps?

1) BEST LINK: 
   Step by Step guide on creating Queue Table, En-queuing, De-queuing, Subscribing PL/SQL to Queue etc.,

    http://www.oracle-developer.net/display.php?id=411

    This is the best link for implementing AQ. This uses PL/SQL for both queuing and de-queuing. 
    Note
    (a) While creating the Queue table, Multi user option must be set to TRUE, for any multi-user scenarios. 
    (b) Commit is a must for both En-queuing and De-queuing (which are considered a Transaction).

2) Reference Link: 
    On creating a Message Type, Queue table with the Message Type, En-queuing, Subscribe to Queue, De-queuing: 
    
    http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:8760267539329,

    
3) Just an additional info: 
    Demo - Advanced Queuing with Oracle Forms 11g:

    http://www.oracle.com/webfolder/technetwork/tutorials/obe/forms/11g/formschataq/formschataq.htm#s1


4) Link to PL/SQL AQ based packages:

    http://docs.oracle.com/cd/B10500_01/appdev.920/a96587/qintro.htm
Interfaces to Advanced QueuingYou can access Advanced Queuing functionality through the following interfaces:

 





Leave a Reply.