Proxxy - XI -JDBC synchronous

81 Views

Hi everybody,

I am facing the following scenario but I really

don't know how to implement it.

I have a synchronous proxy from R/3 to XI. From

XI, I have to retrieve data from Oracle tables.

On the one hand, I need to do a SELECT COUNT. the

result must be the response to the proxy. On the

other hand, I need to do the same query but

without count and now it must return the entire

rows and then map each of them into an IDOC and

then trigger the IDOC to R/3.

Furthermore, After reading the records I need to

update their status to read (for example field

status='R').

How can I achieve that?

Do I need a BPM?

Can I do the SELECT (COUNT), the SELECT * and the

UPDATE at the same query or at the same message?

Thanks in advance,

Regards,

Carlos

Any idea?

Edited by: Carlos Gonzalez on Jan 10, 2008 5:40 PM