Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 03, 2007 at 08:38 AM

    Hi Sunil,

    Have a look at this blog

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

    Regards,

    Sreenivas

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 03, 2007 at 08:42 AM

    Hi,

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

    Have you tested your stored procedure in DB ?

    <b>Cheers,

    *RAJ*</b>

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 03, 2007 at 09:05 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi sreenivas

      Thanks for the reply

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

      Regards

      sunilreddy

  • avatar image
    Former Member
    Oct 03, 2007 at 09:56 AM

    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

    Add comment
    10|10000 characters needed characters exceeded