Skip to Content
avatar image
Former Member

Error in Stored Procedure call Urgent Please

Hi All,

The message structure that is going to the Database is :

<b><?xml version="1.0" encoding="UTF-8" ?>

- <ns0:SP_DB xmlns:ns0="urn:sce-com:xi:dev:mohammf">

- <Test>

- <PP_TEST_P action="EXECUTE">

<RECTYPEIND isInput="true" type="CHAR">AA</RECTYPEIND>

<JENUMBER isInput="true" type="CHAR">76724</JENUMBER>

<COMPANY isInput="true" type="CHAR">BCEO</COMPANY>

<CONSTANT1 isInput="true" type="CHAR">AB</CONSTANT1>

<SYSTEMDATE isInput="true" type="CHAR">08/12/2007</SYSTEMDATE>

<DR_CR_ID isInput="true" type="CHAR">0</DR_CR_ID>

<AMOUNT isInput="true" type="CHAR">934928599475843</AMOUNT>

<MONTH_NUMBER isInput="true" type="CHAR">000008</MONTH_NUMBER>

<COST_CENTER isInput="true" type="CHAR">LosAngeles</COST_CENTER>

<ORDERNO isInput="true" type="CHAR">694950375830</ORDERNO>

<WBS isInput="true" type="CHAR">Southern California Edis</WBS>

<ACCOUNTID isInput="true" type="CHAR">6949503758</ACCOUNTID>

<BATCH_ID isInput="true" type="CHAR">3408102007</BATCH_ID>

<ASSIGNMENT isInput="true" type="CHAR">Technology Solutio</ASSIGNMENT>

<GL_JOURNAL_CATEGORY isInput="true" type="CHAR">GHTF</GL_JOURNAL_CATEGORY>

<PROFIT_CENTER isInput="true" type="CHAR">3434694950</PROFIT_CENTER>

<REFDOCNUMBER isInput="true" type="CHAR">00000000004304300056006056</REFDOCNUMBER>

</PP_TEST_P>

</test>

</ns0:SP_DB></b>

where PP_TEST_P is the Stored Procedure Name

The error i am getting is:

Message processing failed. <b><i>Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'PP_TEST_P' (structure 'Test'): java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'PP_TEST_P' ORA-06550: line 1, column 7: PL/SQL: Statement ignored

8/17/07 7:27:44 PM 80b7cb50-4d30-11dc-8afe-e210bc394725 Error processing request in sax parser: Error when executing statement for table/stored proc. 'PP_TEST_P' (structure 'Test'): java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'PP_TEST_P' ORA-06550: line 1, column 7: PL/SQL: Statement ignored

8/17/07 7:27:44 PM 80b7cb50-4d30-11dc-8afe-e210bc394725 Error while parsing or executing XML-SQL document: Error processing request in sax parser: Error when executing statement for table/stored proc. 'PP_TEST_P' (structure 'Test'): java.sql.SQLException: ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'PP_TEST_P' ORA-06550: line 1, column 7: PL/SQL: Statement ignored </i></b>

Please advice...

XIer

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Aug 18, 2007 at 03:31 AM

    hey

    >>PLS-00306: wrong number or types of arguments in call to 'PP_TEST_P

    this clearly says that there is some difference between the message structure the Stored proc. is expecting and the structure you are sending.please check the arguments

    Thanx

    Aamir suhail

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hey

      are you sure this is the whole stored procedure?its just the declaration part for variables,where is the query in the stored proc.?

      also i m not sure if the following is correct in your XML

      - <ns0:SP_DB xmlns:ns0="urn:sce-com:xi:dev:mohammf">

      have a look at the following and try to create ur DT

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

      Thanx

      Aamir

      Message was edited by:

      Aamir Suhail