Running oracle packages in series/parallel
Posted on 2011-09-20
I have 8 oracle packages created by OWB. These 8 packages are created by 8 different OWB mappings. These packages can be categorized in to two sets:
'feed' and 'stage'.
the packages belonging to feed group are as follows:
Similarly the packages belonging to stage group are as follows
I have a requirement where I need to run the oracle packages in following sequence:
feed1 - stage1 should run in series, similarly feed2 and stage2 packages should run in series and so on..
feed3 - stage3
can all run in parallel..\
Since the process flow tool we are using here is messed up, I would like to create another procedure which executes the above packages the way I have described above..
Please let me know how this can be achieved in a procedure..