Procedure 'abc' expects parameter '@def', which was not supplied

[Former Member]

Hi ,

I am doing a ABAP Proxy to PI to JDBC Stored Procedure synchronous scenario but getting an error as :

Error while parsing or executing XML-SQL document: Error processing request in sax parser: Error when executing statement for table/stored proc. 'db.abc' (structure 'Statement'): java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Procedure 'abc' expects parameter '@def', which was not supplied.

I have a element by name def in the data type.

Any ideas why this error is coming up?

Thanks,

Anu

[Former Member · Accepted solution]

use logsqlstatement in receiver JDBC, it will give you exact sql PI is firing on DB.

using that you can adjust your DT structure to form the right sql.

[Former Member · Accepted solution]

my datatype was wrong and then i added date format in the jdbc communication channel.my interface worked fine.