RE: Emailing Query Results?

From: <ryan_gaffuri_at_comcast.net>
Date: Thu, 28 Oct 2004 15:45:27 +0000
Message-Id: <102820041545.4280.4181141700044D8F000010B82200751150079D9A00000E09A1020E979D@comcast.net>

All queueing means is 'asynchronous activity'. User hits a button. The request gets inserted to a table(or whatever). Users is done and moves on.

Background job polls the table and does the action when it gets around to it.

I haven't worked with the oracle queuing packages so I don't know how good they are.

Concept is:

User does 'X'.
Oracle writes a row to a table.
Background job(dbms_job, unix process, java, or whatever), runs periodically(every 5 minutes, 10 minutes, hour, etc... your call). Polls the table. Sees what it needs to do. Deletes the record. Performance the action.

It's generic. You can find tons of in depth examples on queue programming on the web. Its all the same thing. I've done it with java and with korn shell.
-------------- Original message --------------

How would i do that?

--

http://www.freelists.org/webpage/oracle-l Received on Thu Oct 28 2004 - 10:44:50 CDT