Chris L. wrote:
> How could I launch a package/procedure from VB and avoid the
> client-side wait for the procedure to finish?
>
> I've tried setting up an insertion trigger on a dummy table, then
> invoking the procedure from the trigger (the trigger has the "pragma
> autonomous_transaction")
>
> No success so far. VB inserts the record, the trigger starts the
> procedure, but VB waits for the procedure to finish despite the pragma.
> How could I solve this?
>
> Thanks in advance
> CAL
Oracle version is?
One possible solution is to submit as jobs to DBMS_JOB or DBMS_SCHEDULER
scheduling the job for immediate execution.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Wed Oct 26 2005 - 19:11:55 CDT
