Timer in PL/SQL?
How can we use Timers in PL/SQL?. Can we use?
In Forms, we are using timer using Create_Timer command,
When-Timer_Expired trigger will fire after whatever we have given time duration while creation of timer.
Same process I want to do in PL/SQL. Is it possible in PL/SQL? and How?. Anybody help to give command in PL/SQL.
[Edited by john on 04-17-2001 at 06:29 AM]
Do you have a specific task to achieve?
We're using simple unix script that will sleep and wake up to check file status and decide what actions it needs to take (e.g. send out alert email).
Alternatively, you could write a stored procedures and schedule to run them on regular time interval (good for short-running jobs only).
Hope this helps.
Why donn u see at JOBS !! that should solve u r problem...checkout the docs on ORACLE JOBS..I.E. dbms_job
Vbaskar is absolutely right.
Like in forms if you want any specific task
to execute at a particular time and also wants
to reapeat that task again and again can go for
DBMS_JOB package, which will help you to submit
Your job in the job queue and your job will run
Automatically once it will satisfy when to run your task.
Click Here to Expand Forum to Full Width