Unable to access Stored Procedures via SAP PI

248 Views

Dear Experts,

we have a scenario SOAP <-->PI <-->JDBC (Synchronous) and we are trying to access Stored Procedures using PI (7.31 Java only stack),

We have developed the receiver structure as per the standard format available at various scn blogs, but every time we push the message from SOAP UI we are getting the error as below

Error Message :

Returning to application.
Exception: com.sap.engine.interfaces.messaging.api.exception.MessagingException:
Error processing request in sax parser: Error when executing statement for
table/stored proc. 'SP_XXXX' (structure 'Statement'): java.sql.SQLException:
ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'SP_XXXXX'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

we have browsed enough blogs and have modified the ESR Objects accordinly but still no luck,So request you to let us know the solution for the above error asap.

Regards,

FM

Message was edited by: Moderator - "Urgent" removed from title