Path: news.easynews.com!easynews!sjc-peer.news.verio.net!news.verio.net!sn-xit-01!sn-post-01!supernews.com!corp.supernews.com!not-for-mail
From: Bobby Sardana <sardana@obsoft.com>
Newsgroups: comp.databases.oracle.server
Subject: Oracle 8.1.7 AQ Question
Date: Tue, 09 Oct 2001 23:48:24 -0700
Organization: ObjectSoftware, Inc.
Message-ID: <3BC3EF38.1CAD280F@obsoft.com>
X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.14-5.0 i686)
X-Accept-Language: en
MIME-Version: 1.0
Content-Type: multipart/mixed;
 boundary="------------5A73B40726E731A8C198AA5B"
X-Complaints-To: newsabuse@supernews.com
Lines: 45
Xref: easynews comp.databases.oracle.server:120761
X-Received-Date: Wed, 10 Oct 2001 03:18:44 MST (news.easynews.com)
--------------5A73B40726E731A8C198AA5B
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

I want to find out if the following is possible with AQs:

a. A message is enqueued with an expiration in AQ. I want to assign a
trigger to be fired when the message expires and is moved to the
exception queue.

Now the questions:

1. Is (a) possible?
2. If (a) is possible then what is the sytax to assign the trigger?

All answers are appreciated.

Regards,

Bobby Sardana.
sardana@obsoft.com

--------------5A73B40726E731A8C198AA5B
Content-Type: text/x-vcard; charset=us-ascii;
 name="sardana.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Bobby Sardana
Content-Disposition: attachment;
 filename="sardana.vcf"

begin:vcard 
n:Sardana;Bobby
x-mozilla-html:FALSE
org:ObjectSoftware, Inc.;R & D
adr:;;;;;;
version:2.1
email;internet:sardana@obsoft.com
title:Engineer
x-mozilla-cpt:;4320
fn:Bobby Sardana
end:vcard

--------------5A73B40726E731A8C198AA5B--