Unable to access Stored Procedures via SAP PI

[former_member399424]

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

[former_member399424 · Accepted solution]

Dear All,

Thank you all for your prompt response.

The issue got resolved and there was no any change in structure as the issue was with the case i.e. In SP input & output parameters are all defined in lower case and in PI we had defined them in upper case & once we got the case changed, we were able to connect to DB.

Thanks & Regards,

Mohammed

[Harish · Accepted solution]

Hi Mohammed,

Thanks for update. Can you please also close the thread? Please refer the below blog

regards,

Harish

[nabendu_sen]

Hi,

This is an issue with Data Type passed to Stored Procedure.

Check the suggestion from

https://community.oracle.com/thread/363839?tstart=0

ORA-06550: line1,column7: PLS-00306: wrong numb... | Oracle Community

Regards,

Nabendu.

[Harish]

Hi Mohammed,

The problem is in the data for column 7. I would suggest to check the stored procedure and try to test the same data with database (direct use of store procedure in data base).

regards,

Harish

[former_member183910]

Hi Mohammed,

can you let me know the input xml which is going to JDBC adapter?

What are input and output parameters of stored procedure?

Thanks

Sandeep Maurya