ERP Times

Home

AOL

Reports

AIA

SOA

R12

About Us

6 Aug 2012

API to purge records from advance queue

How to clear a queue in Oracle AQ

DECLARE
 t_purge_q dbms_aqadm.aq$_purge_options_t;
BEGIN
  dbms_aqadm.purge_queue_table('XXQUEUE', NULL, t_purge_q);
END;
 /

XXQUEUE is your queue name
No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Blog Archive

  • ▼  15 (4)
    • ▼  Jan (4)
      • BPEL Process Features
      • What Is BPEL?
      • SOA, Web Services, and REST
      • SOAP and REST
  • ►  14 (6)
    • ►  Dec (1)
    • ►  Nov (1)
    • ►  Oct (1)
    • ►  Aug (1)
    • ►  Jul (1)
    • ►  Jan (1)
  • ►  13 (2)
    • ►  Oct (1)
    • ►  Sept (1)
  • ►  12 (5)
    • ►  Nov (2)
    • ►  Aug (2)
    • ►  Mar (1)
  • ►  11 (5)
    • ►  Nov (1)
    • ►  Sept (1)
    • ►  Aug (1)
    • ►  Feb (2)
  • ►  10 (5)
    • ►  Dec (1)
    • ►  Nov (2)
    • ►  Oct (1)
    • ►  Jul (1)
  • ►  09 (3)
    • ►  Sept (1)
    • ►  Aug (1)
    • ►  Apr (1)
  • ►  08 (2)
    • ►  Oct (1)
    • ►  May (1)
  • ►  07 (2)
    • ►  Nov (1)
    • ►  Jan (1)

Pageviews

Popular Posts

  • What is the difference between MTL_SYSTEM_ITEMS,MTL_SYSTEM_ITEMS_B tables?
    What is the difference between MTL_SYSTEM_ITEMS,MTL_SYSTEM_ITEMS_B tables? mtl_system_items is a synonym that points to mtl_system_i...
  • How to cancel Scheduled Concurrent Programs in Oracle apps
    From Front End: 1) Login with the same user, who scheduled the concurrent program 2) Go to view requests from the responsibility it...
  • REP-0110: Unable to open file error while running RDF report
    REP-0110: Unable to open file error while running RDF report Forcing NLS_NUMERIC_CHARACTERS to: '.,' for XDO processing  APPLLC...
  • Purchase Order Authorization Status
    There are 8 authorization status that a purchase order can have. The table below lists all the statuses along with their meanings. ...
  • Starting lot number prefix is required when Lot Control = Full lot control
    While releasing a part from Agile getting below error. Error: Starting lot number prefix is required when Lot Control = Full lot control...

Other Popular Oracle Blogs

  • Ora FAQ
  • AnilPassi Blog
  • Oracle Docs

About ERP Times

  • About ERP Times
seo






© ERP Times. Simple theme. Theme images by fpm. Powered by Blogger.