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

  • SCA vs SOA
    Service Component Architecture VS Service Oriented Architecture It's a set of specifications that defines an assembly model for com...
  • Signal 11- Error in oracle apps reports
    Signal 11- Error in oracle apps reports One of the most common error messages we see in Oracle E-business suite reports is  à  signal 11...
  • Introduction to AIA PIP
    What is AIA Application Integration Architecture is an open, standards-based platform that is designed to ease integration of disparate app...
  • Overview on Multi-Org Structure
    Overview on Multi-Org Structure What is Multi-Org Multi-Org is an enhancement to Oracle applications that enables you to model multiple bus...
  • 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.