Procedure calling.

[karry450]

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

[arvind_ds]

(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

[Pagadrai]

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.

[ray.wurlod]

I am writing flat file to oracle using Bul Loader

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