DSXchange

Hi Friends,


I am writing flat file to oracle using Bul Loader in DS , I want to call a procedure with date parameters after the load happens.

But the bulk loader doesnt seem to have any option to call after SQL.

Could any one please suggest me

Thanks
Karthik

(1) Create a separate job to call stored procedure and place that job after your oracle bulk load job in a job sequence and then run the job sequence.

(2) Create a script to call the procedure and use that script in after job sub-routine of oralce bulk load job.

HTH

Hi Karthik,

One more Option to what is mentioned above:-
You can write a server routine and call it in after job Subroutine.
Here you can also specify to execute it only of the job finishes successfully.

karry450 wrote:I am writing flat file to oracle using Bul Loader

Ah, yes, so many projects end up using a Bul Loader.