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...
  • SCA vs SOA
    Service Component Architecture VS Service Oriented Architecture It's a set of specifications that defines an assembly model for com...
  • 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...
  • Query to fetch concurrent program duration and user details
    Query to fetch concurrent program duration and user details SELECT fcr.request_id,          fcr.actual_start_date,          fcr.actual_c...
  • Oracle Pipelined Table functions
    Oracle Pipelined Table functions Do you want to know/learn? ü What are Oracle Table functions? ü How could these ...

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.