Re: executing a stored procedure

You should look at dbms_job. This will let you submit a job to execute your procedure.

Nick Butler wrote:
>
> I have a stored procedure that will take a long time to execute (about 12
> hours).
>
> Is there a way to execute this stored procedure
> (from say another stored procedure)
> and be able to continue without
> waiting for the long stored procedure to finish?
>
> If anyone knows of a method please let me know.
Received on Mon Aug 04 1997 - 00:00:00 CDT