Skip to Content
Former Member
Jul 04, 2006 at 10:39 AM

How to pass values at runtime in JDBC - XI - File scenario


Hi friends,

In my scenario, data is coming from R/3 and i need to filter records from oracle database based on this data. There are 4 database tables that need to be queried using 2 select statements. The resultset after the execution of query will be mapped to the target flat file structure.

here are my queries:

1) Can I avoid BPM as data needs to be collected from the two database calls which involves two sender JDBC adapter instances with only one target structure?

2) Can I use stored procedure in this scenario? If yes, than how to pass values to stored procedure at runtime via sender JDBC adapter.

Thanks and regards,

Nitin aggarwal.