OraFAQ Forum: SQL & PL/SQL » Execute stored procedure after interval

Home » SQL & PL/SQL » SQL & PL/SQL » Execute stored procedure after interval (Oracle 11g)

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

Execute stored procedure after interval [message #641391]

Fri, 14 August 2015 02:30

christian.delbianco
Messages: 1
Registered: August 2015

Junior Member

Hello. I am new in ORACLE - PL/SQL.
What I need to do is run in a separate call or sql statement (in a separate thread) a task, job or what ever that after an amount of seconds call a stored procedure.

Also, this thread must be reset: this means that if I call again it, the timer must be restarted from zero, starting a new interval counting.

Is there any oracle way to accomplish that ?

Report message to a moderator