Skip to Content
0
Jun 24, 2013 at 11:39 AM

JDBC sender to call a stored Procedure

786 Views

Hi Guys,

We have Scenario from JDBC to IDOC.We are using Oracle DB,at the database side we have a stored Procedure and inside the Procedure we are accessing multiple table.

My query is how can we excecute a stored procedure by using EXECUTE at the sender JDBC.I wrote the query as :

EXECUTE name.Packagename.Storedprocedurename.

But it is giving error like: Invalid SQL statememnt.

Can anyone please on this??