Does anyone have experience with AQ tables? I would like to put a trigger on my AQ table so that when a message comes in, it will automatically fire off a job to dequeue the message. I opened a TAR and was told that I can put a trigger on the table, but it's not recommended. When I asked why, they said 'it just wasn't recommended'. I'm curious if anyone actually knows why I shouldn't or if I really can. It really seems to be a slick way to handle the messages, but if it will cause problems, I'd like to know that upfront.
Thank you - Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
