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,
<i>In my scenario, data is coming from R/3 and i need to filter records from oracle database based on this data</i>
Am not sure.. Can you please elaborate on this?? How is data from R3 related to your Oracle Database?
Next, ASFAIK, you cannot use a Sender JDBC adapter to call an oracle Stored Procedure. Reason being that Oracle Stored Procedures return a Cursor and not a resultset.
So, either you will have to use a Sender JDBC adapter with a single Select query ( can't you make a single Select Statement instead of multiple ones)
Or, you can use the receiver JDBC adapter to make the Select to the database using a BPM.