OraFAQ Forum: Server Administration » Running a procedure in back ground

Home » RDBMS Server » Server Administration » Running a procedure in back ground

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Running a procedure in back ground [message #369981]

Wed, 22 November 2000 01:43

ranjith
Messages: 10
Registered: November 2000

Junior Member

Hi,
Any idea how to run a block of PL/SQL in the back ground? Once invoked,this script is supposed to create/update records depending on a time interval without user interaction..
Tx
Ranjith

Report message to a moderator

Re: Running a procedure in back ground [message #369982 is a reply to message #369981]

Wed, 22 November 2000 04:02

John R
Messages: 156
Registered: March 2000

Senior Member

Use the DBMS_JOB package to run processes in the background and have them repeat at set intervals.

Report message to a moderator

Re: Running a procedure in back ground [message #369994 is a reply to message #369982]

Thu, 23 November 2000 09:27

ranjith
Messages: 10
Registered: November 2000

Junior Member

Tx John,
But I want this to be invoked from a serverside script( using PHP/ASP)
Is that possible..
Ranjith

Report message to a moderator

Previous Topic:	How do i select an element of a type object in SQL
Next Topic:	Re: Query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 04 12:30:33 CDT 2024