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

Home -> Community -> Usenet -> c.d.o.server -> Re: stored procedure

Re: stored procedure

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Fri, 29 Oct 1999 21:23:21 +0200
Message-ID: <941225034.17791.0.pluto.d4ee154e@news.demon.nl>


What can be done is run a procedure as a batch job using the dbms_job package.
You won't be able to bind that to a certain processor though.

Hth,

--
Sybrand Bakker, Oracle DBA
Andreas Schwaiger <andreas.schwaiger_at_strasser.at> wrote in message news:3819da04.0_at_news.kabsi.at...
> is there a possibility to run a stored procedure in the background? (dual
> processor machine)
> I have a stored procedure which set a flag in a table when the "work" in
the
> procedure is finished.
> I will start more tasks of this procedure and look at this flag after a
> specified time.
> How can I do this?
> Many thanks for helping
>
> Andi Schwaiger
> Austria
>
>
Received on Fri Oct 29 1999 - 14:23:21 CDT

Original text of this message

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