cancel
Showing results for 
Search instead for 
Did you mean: 

com.ibm.db2.jcc.a.SqlException:

Former Member
0 Kudos

Hi

I am doing RFC to JDBC Scenario using storedprocedures

While executing the scenario i am getting the following error in communication channel monitoring.

Error while parsing or executing XML-SQL document: Error processing request in sax parser: Error when executing statement for table/stored proc. 'EMU.INSERTSAP1' (structure 'Statement'): com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -440, SQLSTATE: 42884, SQLERRMC: EMU.INSERTSAP1;PROCEDURE

Can anybody give solution

Regards

sunilreddy

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Sunil,

Have a look at this blog

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

Regards,

Sreenivas

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi

1)Check the name of your Procedure

2)Check the parameters your are passing to it

3)Execute the procedure in DB and see whether it gives the desired results

4)Receiver Structure should be correct

Configuring the Receiver JDBC Adapter

http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

SQL Error means either you are passing wrong arguments or the values you are trying to insert cannot be inserted.

Thanks

Former Member
0 Kudos

Hi Sunil,

The SQLSTATE: 42884 says that "No function or procedure was found with the specified name and compatible arguments."

Check whether you are passing correct arguments to the procedure also check whether the procedure name is correct or not.

Test your stored procedure separately and then execute your scenario.

Regards,

Sreenivas

Former Member
0 Kudos

Hi sreenivas

Thanks for the reply

But How I can check The Stored procedure.Give me the details.

Regards

sunilreddy

Former Member
0 Kudos

Hi,

Check the structure of the jdbc data type in the IR.

Have you tested your stored procedure in DB ?

<b>Cheers,

*RAJ*</b>