Reg:Sender Stored Procedure

[Former Member]

Hi All,

Could anyone tell me how to pass the input parameter values to the sender JDBC structure , using stored procedure.

Thanks in Advance,

Lavanya.B

[Former Member · Accepted solution]

Hi Lavanya,

In Query SQL Statement field in Sender JDBC adapter CC Config ->

"Specify an SQL EXECUTE statement to execute a stored procedure, which contains exactly one SELECT statement."

http://help.sap.com/saphelp_nw70/helpdata/EN/7e/5df96381ec72468a00815dd80f8b63/frameset.htm

Regards,

Ramesh

[Former Member · Accepted solution]

Hi Ramesh,

Thanks for the quick reply.

Could any one suggest me whether can I invoke stored procedure ,sender JDBC ,for the Oracle database.

Lavanya.B

[Shabarish_Nair · Accepted solution]

oracle DB is supported

[former_member192892 · Accepted solution]

Hello Lavanya,

Oracle Stored Procs return Cursor objects and not Resultset. Hence it wouldn't be possible to ue them. A work around is to use Oracle table functions

Regards

Varun

[Shabarish_Nair · Accepted solution]

Varun is correct. I had skipped that information but it depends on your SP level. I think from XI 3.0 SP 16 onwards this issues isnt there.