Using Oracle Stored Procedure in a package in a Sender JDBC Adapter

[pi_consultant1]

Hello PI friends,

I've a scenario where I have to call an Oracle Stored Procedure in a package . This Stored Procedure returns a Cursor.

My question is, is it possible to call this Stored Procedure that returns a Cursur in a Sender JDBC Adapter? And how is the parameter in the Adapter looks like?

Thank you in advance,

John

[pi_consultant1]

Does anyone know the solution for this issue???

Thank you...

[rajasekhar_reddy14]

Hi John,

there is a alternative to call Stored procesude using JDBC sender adapter, couple of day back i read Michal blog.

search in scn.

http://scn.sap.com/thread/1574165

Regards,

Raj

[pi_consultant1]

Hi Raja,

Thank you...

So the setting in the JDBC adapter for the Packagename and ProcedureName looks like this? packageName.procedureName()

And how can I process the stored procedure that returns a Cursor?

Im looking forward to your answer,

John

[baskar_gopalakrishnan2]

IMO, sender adapter does not support oracle stored procedure. Even you can see Bhavesh reply on this thread ..

http://scn.sap.com/thread/218805