Implementing stored procudure
Posted: Fri Sep 17, 2010 9:14 am
Hi all,
I have a below requirement , can you please suggest me how best to achieve this
1.I have one oracle table which will contain some columns (daily refresh)
2.I need to read the values from the the above table and pass them to an SP.
3 Need to execute the sp with those values as params.
4.Get the output of the sp into a sequential file.
5.Ftp the file.
I am passing the values of table in point 1 to a file and then to an sp as input params , but I'm not sure how to "capture" the output of the stored procdure.
Thanks in advance
I have a below requirement , can you please suggest me how best to achieve this
1.I have one oracle table which will contain some columns (daily refresh)
2.I need to read the values from the the above table and pass them to an SP.
3 Need to execute the sp with those values as params.
4.Get the output of the sp into a sequential file.
5.Ftp the file.
I am passing the values of table in point 1 to a file and then to an sp as input params , but I'm not sure how to "capture" the output of the stored procdure.
Thanks in advance