Creating Jobs In Oracle 10g
Hi All,
I need to create a job in PL/SQL which execute different procedures sequentially.What i exactly need is to schedule 3 different procedure and one package which are dependent on each other so if first procedure fails second does'nt execute.As i know i can associate only one procedure/package with single job.So how i can call three different procedures at a time .I am using Oracle 10g .So can DBMS_SCHEDULER help me?
Please Help.
Regards:
Gagan Deep Kaushal