write a procedure (p1) to check the condition and based upon the condition
call packaged procedure (p.p2) from it.
use dbms_job to schedue the execution of procedure p1.
Atul
-Original Message-
Sent: Tuesday, August 20, 2002 6:03 PM
To: Multiple recipients of list ORACLE-L
Any idea
I know how.
Ciprian MAFTEI
Telequote Network
Computer Systems Analyst
Any idea how to schedule the execution of a PL/SQL package? and if a
certain condition is acomplished to execute again (later in the
night) the same package until the same condition is not anymore fulfilled?
In
Title: RE: how to schedule an execution in PL/SQL
hi!
i guess you should just have a look at the DBMS_JOB package!
i would start with reading the documentation of this standard
oracle package.
cheers
-dieter
-Original Message-
From: mac [mailto:[EMAIL PROTECTED]]
Sent:
Check out the DBMS_JOB supplied plsql package
hth
connor
--- mac [EMAIL PROTECTED] wrote: Any idea how to
schedule the execution of a PL/SQL
package? and if a certain
condition is acomplished to execute again (later in
the night) the same
package until the same condition is not anymore