Receiver JDBC Adapter

Hi guys,

I am trying a scenario in which SAP R3 will send request to Oracle database using JDBC adapter.

The JDBC adapter will then select the number of rows from database , there is a flag maintained in the database which i want to update when the records are selected .

Is it possible to have select and update ( multiple queries ) for one JDBC adapter.

And also is it necessary to take precaution if the volume of the data read from the JDBC adapter is huge ( 30000 ).

Regards,

Keith.