Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> VB, Oracle, Asynchronous execution of procedures

VB, Oracle, Asynchronous execution of procedures

From: Chris L. <diversos_at_uol.com.ar>
Date: 26 Oct 2005 11:20:27 -0700
Message-ID: <1130350827.761979.39860@g44g2000cwa.googlegroups.com> 





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

Received on Wed Oct 26 2005 - 13:20:27 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US