Calling Stored Procedure problem

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Calling Stored Procedure problem

jrautner
This post has NOT been accepted by the mailing list yet.
Hallo,

i'd like to ask if is somewhere example of calling stored procedures from bpel process with in and out params. I was able to call procedure that is without params. Is there in wsdl some attribute like paramOrder in PreparedStatement?

When i tried to call stored procedure with params i get this error:

java.sql.SQLException: Exception in processing SQL.call SOAPMS_CORE.TEST_OPENESB(?,?,?) Reason: Param In and out
 by index is missing:: 1 SQLState: 99999 ErrorCode: 17041

Thank you
greetings
Jakub Rautner