Skip to Content
0
Former Member
Mar 05, 2009 at 06:58 AM

JDBC-FILE(Stored procedure)

22 Views

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