Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question