|Advanced Queuing In Oracle9i - Get to grips with the basics of advanced queuing in Oracle9i.|
Manohar.K said...Tried with this document did'nt worked, requires more specific document.
Tim... said...Sorry to hear it didn't work for you. The example in this article works fine for me. If you want to discuss your problem try posting it on your forum. Perhaps we can get to the bottom of your problem there.
Alan Green said...Worked fine for me (although I didnt create the separate schema)
This was exactly what I was looking for - a simple set of scripts (that worked) to embellish as I go!
Monalisa said...Its good to give priliminary idea about q.
Nick said...Thanks for example,
but can you give more specific example of transaction any table's data to another instance?
Andy Campbell said...Looks like there is an error in the commands to create the aq_user. You grant connect to aq_admin
GRANT connect TO aq_admin;
Thanks for the heads-up. I've corrected it now.
Vasudev said...Hi Tim,
The last section of the "Advanced Queuing In Oracle9i" article reads:
The DEQUEUE_OPTIONS_T, DEQUEUE_OPTIONS_T and MESSAGE_PROPERTIES_T types can be used to vary..."
Should it read:
The ENQUEUE_OPTIONS_T, DEQUEUE_OPTIONS_T and MESSAGE_PROPERTIES_T types can be used to vary..."?
Dodgy copy/paste. :) I've corrected it now. Thanks for the heads-up.