Calling a Stored Procedure after ORA Bulk Stage

[arpitchopra]

Hi everyone,

I have a job structured like this:


Orcl OCI Src ---> Transformer ---> Seq File ----> ORA Bulk Tgt


I have 2 stored procedures where I drop indexes and constraints on the Tgt table before loading and then re-create these indexes after the load is complete.
As of now, I call the 1st SP (to drop indexes) in the After SQL of source (just a way around). I need to call the 2nd SP after the load has been completed.
One way is to create another job having just this stored procedure and creating a sequence where that stored proc is called after this loading job is completed. Is there any other way to achieve this ?