Re: PL/SQL Sessions?

From: Steve Dover <killspam.swd_at_strata-group.com>
Date: 1997/06/12
Message-ID: <33A0887F.249A65CA_at_strata-group.com>#1/1


Bryan Dollery wrote:
>
> Hi,
>
> Does anybody know how to create a new session in PL/SQL.
>
> I need to create another session so that I can start procedures, held
> within packages, asynchronously. That is, I wish to start a procedure, and
> not await its outcome. I think that I can do this only by creating a new
> session for the routine to run in.
>
> The routine could start a new session, run its methods in this, and return
> immediately to the calling session.
>
> This would be similar to using the fork() function in C/C++ under Unix.
>
> Any help would be greatly appreciated.
>
> Bryan
> --------------------------------------------------
> Twas brillig, and the slithy toves
> Did gyre and gimble in the wabe:

Look into dbms_job package.

Cheers. Received on Thu Jun 12 1997 - 00:00:00 CEST

Original text of this message