Q: Asynchronous processing

From: huh <huhhy_at_rocketmail.com>
Date: Tue, 3 Aug 1999 12:38:01 +0200
Message-ID: <7o6grt$2pj6$1@ns.felk.cvut.cz>

Hi,

Can someone suggest me how to invoke a PL/SQL procedure asynchronously? I've got a table A with columns task and status. I need a PL/SQL procedure to be run in case the status has changed. I can't use a simple trigger because
the procedure's task is extensively time consuming and I can't block any connection for a long time.

My intention is to run "somehow" this procedure from trigger. I guess ORACLE uses sheduled jobs.
Can I use it? Programmatically create a job (which will execute my procedure)
and programaticaly run this job from trigger....

Pointers to manuals (or other useful accessible info sources) are good for me too.

Maybe there is a more elegant way to do this. What about limitations?

TIA --
Thank you for keeping >anti-spam< habit: not including my address in your reply. Received on Tue Aug 03 1999 - 05:38:01 CDT