JDBC Adapter Sender with Stored Procedures

[Former Member]

Hi all,

I have some questions about using JDBC Adapter with Stored Procedures:

1) Is it possible to execute a stored procedure without input parameters?

2) If yes, I just have to map the action (EXECUTE)?

I was taking a look at this weblog:

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

But in the example, there is two input parameters.

Points will be given,

Thank you very much,

Daniela

[Former Member · Accepted solution]

Oh sorry, it is not a Sender JDBC, it is a Receiver one. I made a mistake.

And it is synchronous too.

In fact the scenario which I'll implement is Abap Proxy <-> XI <-> JDBC.

Sorry for the mistake,

Daniela

[bhavesh_kantilal · Accepted solution]

Have not tried it but it will work without Input Parameters. Just follow the blog I have posted in my previous reply and just ignore the mapping of only the Input Parameters but create the Actio = EXECUTE.

Regards

Bhavesh

Message was edited by:

Bhavesh Kantilal

[Former Member · Accepted solution]

Bhavesh,

Thank you very much. I'll some tests to see if it works!

Regards,

Daniela

[bhavesh_kantilal]

Hi,

Are you trying to execute a stored procedure on a Sender JDBC adapter or a Receiver JDBC adapter?

If Sender JDBC adapter, which database are you trying to do this on?

For Receiver JDBC adapter yes, you can execture the Stored Procedure without Input Parameters. Just make sure you have all the Output Parameters mapped as Blank Constants including the ACTION = EXECTUE

Also look into this blog,

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

Regards

Bhavesh

[prabhu_s2]

...this is for a sync call

Message was edited by:

Prabhu S

[prabhu_s2]

Sender JDBC with SP will not be supported for cursors