Hi,
I have a Oracle stored procedure which can take tables as in parameter. does a BULK insert, it does some other process too.
My main objective is not to call stored procedure for each row of Input link. I want to pass all values of the input link as array.
Is there any way to achieve it?
Pass all records of Input Link as array parameter in STP
Moderators: chulett, rschirm, roy
Hi,
The most simple way is to load a temp table and then invoke the SP nce to do the work.
If there is no objection/reason not to implement all logic in DS I prefer a DS solution over a SP one.
IHTH,
The most simple way is to load a temp table and then invoke the SP nce to do the work.
If there is no objection/reason not to implement all logic in DS I prefer a DS solution over a SP one.
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org