cancel
Showing results for 
Search instead for 
Did you mean: 

Invoke stored procedure from JDBC Adapter

Former Member
0 Kudos

Is there a tool that generates interfaces for stored procedure(ORACLE PL/SQL) like RFC or IDOC adapters?

Accepted Solutions (0)

Answers (2)

Answers (2)

bhavesh_kantilal
Active Contributor
0 Kudos

Hi Denis,

I dont think there is any such tool.]

To generate a Stored Procedure of your Oracle DB, all you will have to do in your <b>JDBC adapter configuration</b> is give the name of the Stored Procedure under <Table> and you will have to give "<b>execute</b>" as the value under action attribute.

Just check this link. Hope it helps,

http://help.sap.com/saphelp_nw04/helpdata/en/b0/676b3c255b1475e10000000a114084/content.htm

http://help.sap.com/saphelp_nw04/helpdata/en/4d/8c103e05df2e4b95cbcc68fed61705/content.htm

Just check this blog of Sriram wherein a stored procedure of a MaxDB Database is called.

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

I have implemented a scenario which requires an Oracle stored procedure to be executed and so, if you do need any further info, let me know.

Hope this info helps,

Regards,

Bhavesh

Former Member
0 Kudos

Good day Denis.

You can use the Reciever JDBC adapter inorder to trigger stored proc. on your target database.

Follow the defined XML structure needed for the JDBC communication channel

JDBC adapter configuration

 <StatementName5>

<storedProcedureName action=” EXECUTE”>

    <table>realStoredProcedureeName</table>

<param1 [isInput=”true”] [isOutput=true] type=SQLDatatype>val1</param1>

</storedProcedureName >  

  </StatementName5>

Best Regards

Nimrod