Sunday, June 30, 2013

AQ in Oracle Apps

Creating Queues in Oracle Apps:



Grants on Queues:




Enqueue CLOB data in AQ$_JMS_TEXT_MESSAGE:
Below code is used to enqueue the CLOB  data in custom queue which was created above,