on 10-03-2007 9:20 AM
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
Hi Sunil,
Have a look at this blog
/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures
Regards,
Sreenivas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Check the structure of the jdbc data type in the IR.
Have you tested your stored procedure in DB ?
<b>Cheers,
*RAJ*</b>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.