Synchronous Scenario - RFC Sender to JDBC (Stored procedure)

[Former Member]

Hi ,

I would like to know if -

1) If the RFC sender can be synchronous?

2) A JDBC receiver that call a oracle stored procedure can be synchronous?

Has anybody worked on a such a scenario - RFC sender to JDBC receiver using a stored procedure and the response of the stored procedure is sent back to the RFC caller?

[kenny_scott · Accepted solution]

Hi Arvind,

the answers are yes and yes,

i.e., for ref.

(1)

[#730870 FAQ XI 3.0/ PI 7.0/ PI 7.1/ PI 7.11/ PI 7.2 RFC|http://service.sap.com/sap/support/notes/730870]

==========

" Q 9: Which flavous of RFC are supported?

A: RFC Adapter supports synchronous RFC (sRFC, sometimes also called

only RFC) and transactional RFC (tRFC). Queued RFC (qRFC) with

inbound queues and asynchronous RFC (aRFC) are not supported. An

sRFC will result in a synchronous best effort (BE) message; "

============

(2)

[Configuring the Receiver JDBC Adapter|http://help.sap.com/saphelp_nwpi711/helpdata/en/48/465581929734d9e10000000a42189d/content.htm]

"You can call stored procedures in the database by using transfer parameters. In the case of synchronous queries, results from database queries or return values of stored procedures can also be transferred."

REgards

Kenny

[former_member204873]

hi,

Check this thread:

For JDBC Receiver synchronous structure check:

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

Thanks.

[Former Member]

Hi,

1) If the RFC sender can be synchronous?

Answer... Yes we can use sender RFC for synchronous.

2) A JDBC receiver that call a oracle stored procedure can be synchronous?

Answer... yes we can use JDBC at receiver side for synchronous but i dont have idea with stired procedures.