Re: Oracle trigger equivalent of MSSQL trigger

<response>
<relevant response>

When discussing Queues in Oracle, I generally look at Oracle's Message Queue capability. It's called Oracle Advanced Queueing, supports user defined payloads, interfaces easily (or natively) with a lot of 3rd party queue systems, and comes with a significant & well documented API. Since it's implemented as tables, you can do joins and analysis (and even rewind the queue) although queue interaction is done through the API - from DB or app triggers, from SMTP or TCP/IP, etc.

Not sure whether you can use it in your environment - you might want to check it out at http://otn.oracle.com - some doc links for Oracle 9.2 database:

Application Developer's Guide - Advanced Queuing http://otn.oracle.com/pls/db92/db92.to_toc?pathname=appdev.920%2Fa96587%2Ftoc.htm&remark=docindex

Supplied PL/SQL Packages and Types Reference for the API http://otn.oracle.com/pls/db92/db92.to_toc?pathname=appdev.920%2Fa96612%2Ftoc.htm&remark=docindex
</relevant response>
<sotto voce>

I find this much better than trying to reinvent the wheel, but some people enjoy low level coding and long term maintenance on redundant infrastructure technology - beats maintaining business code I guess. <g>
</sotto voce>
</response>

/Hans Received on Thu Jun 24 2004 - 09:29:50 CDT