I am creating an Oracle Developer form which will take the query created by the user and specified runtime (also by user) and saves it in two columns of a Oracle table. Is there a facility in oracle which can trigger off the saved query when the sysdate becomes equal to specified runtime?
Thanks
Hi Columbus.
The DBMS_JOB package should do the trick. See documentation on Oracle Supplied PL/SQL Packages and Types Reference for details on parameter requirements.
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/jobq.htm#9499
Last Wiki Answer Submitted: July 11, 2006 10:59 am by L902suedoe0 pts.
If you live outside the United States, by submitting your email address you consent to having your personal data transferred to and processed in the United States.