HI Experts,
I have a requirement as follows
stored procedure
->stored procedure
->File.
ie initially a stored procedure would be executed(which i could execute with help of option in the jDBC communication channel).This would result in a resultset being given as output.
This will be associated with sender datatype.Now this is to be given as input to a second stored procedure.
The second stored procedure will return output which i need to map into a target file structure.
Can anybody guide me in this regard?Sender will be JDBC and target will be file adapter,but how can i execute the second stored procedure?
The blogs simply says the option for one stored procedure to file.Is there any other help or blogs?
Thanks in advance