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 ?
Calling a Stored Procedure after ORA Bulk Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 35
- Joined: Mon Nov 01, 2010 2:48 am
- Location: New Delhi
Calling a Stored Procedure after ORA Bulk Stage
Arpit Chopra