Re: Running stored procedures asynchonously
From: DanHW <danhw_at_aol.com>
Date: 27 Apr 1999 01:01:38 GMT
Message-ID: <19990426210138.08426.00001942_at_ng94.aol.com>
Date: 27 Apr 1999 01:01:38 GMT
Message-ID: <19990426210138.08426.00001942_at_ng94.aol.com>
> have a program written in VB5.0 using Oracle database 8.4 through Oracle
>OLE objects.
>There are several stored procedures on Oracle server.
>My question is does anyone know how to run the stored procedures
>asynchronously.
>That is start running stored procedure B, while stored procedure A is
>running ???
> mdbDatabase.DBExecuteSQL ("BEGIN scott.A; END;")
> mdbDatabase.DBExecuteSQL ("BEGIN scott.B; END;")
>
>I think I need different Database object, maybe running in different threads
>????
Look at the DBMS_JOB package.
Dan Hekimian-Williams Received on Tue Apr 27 1999 - 03:01:38 CEST