How to use Oracle stored procs?

[Former Member]

Hi,

Could you please explain, how to use Stored Procedures using

JDBC Sender Adapter and

JDBC Receiver Adapter

I have File to JDBC or IDoc to JDBC.

and JDBC to IDoc scenario.

where we do handle this stored procedures code.

thanks in advance.

Best regards

Gopi

[Former Member]

Hi,

Stored procedures are used mostly in Synchronous transmission.

The data coming from source is stored for specific period of time at the destination and sent back to the source.

Just have a look at these links:

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

http://help.sap.com/saphelp_nw04/helpdata/en/45/023c41325fa831e10000000a1550b0/frameset.htm

/people/sriram.vasudevan3/blog/2005/02/14/calling-stored-procs-in-maxdb-using-sap-xi

regards,

Gunasree.

[Shabarish_Nair]

in the receiver channel ->

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Look at the structure and drill down to the XML tag statement5 to get an idea !!!