Calling PL/SQL procedure from a Data Stage job
Posted: Tue Dec 14, 2004 10:47 am
Hi,
I have a PL/SQL procedure which has 5 cursors to select the data from the source systems and loads the data into a target table. The PL/SQL is robust and is working fine. I have a requirement where I'm asked to use the same PL/SQL. So, I have to call the procedure using Data Stage. Also, I need to get the load statistics like no. of rows read, no. of rows inserted, time taken etc. If I'm using the stages to select and load the data then I can get the statistics easily. But when I call the procedure from a DS job then how can I get the statistics?
First of all, I need to know whether calling a PL/SQL procedure from a DS job is possible. If yes, then how can I get the load statistics of the procedure using Data Stage job.
Cheers,
Mohan
I have a PL/SQL procedure which has 5 cursors to select the data from the source systems and loads the data into a target table. The PL/SQL is robust and is working fine. I have a requirement where I'm asked to use the same PL/SQL. So, I have to call the procedure using Data Stage. Also, I need to get the load statistics like no. of rows read, no. of rows inserted, time taken etc. If I'm using the stages to select and load the data then I can get the statistics easily. But when I call the procedure from a DS job then how can I get the statistics?
First of all, I need to know whether calling a PL/SQL procedure from a DS job is possible. If yes, then how can I get the load statistics of the procedure using Data Stage job.
Cheers,
Mohan