Error in Stored Procedure call Urgent Please

[Former Member]

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]

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

[Former Member]

Thanks for your reply Aamir, i am stuck here and urgently need some help.

The stored procedure that has been written is:

CREATE OR REPLACE PROCEDURE KUMARJA.PP_TEST_P

(

RECTYPEIND CHAR,

JENUMBER CHAR,

COMPANY CHAR,

CONSTANT1 CHAR,

SYSTEMDATE CHAR,

DR_CR_ID CHAR,

AMOUNT CHAR,

MONTH_NUMBER CHAR,

COST_CENTER CHAR,

ORDERNO CHAR,

WBS CHAR,

ACCOUNTID CHAR,

BATCH_ID CHARR,

ASSIGNMENT CHAR,

GL_JOURNAL_CATEGORY CHAR,

PROFIT_CENTER CHAR,

REFDOCNUMBER CHAR

)

Pls tell if theres anything wrong with this...

The message that is going in is:

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

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

- <Test>

- <storedProcedureName action="EXECUTE">

<table>PP_TEST_P</table>

<RECTYPEIND isInput="1" type="CHAR">CC</RECTYPEIND>

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

</storedProcedureName>

</Test>

</ns0:SP_DB>

Pls advice...

Xier

[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