Structure for Stored Procedure Call

[Former Member]

Hi All,

Guys I am trying to call a stored procedure call using receiver jdbc adapter...

This is the outgoing message:

<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">

<table>PP_TEST_P</table>

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

</PP_TEST_P>

- <PP_TEST_P action="EXECUTE">

<table>PP_TEST_P</table>

<RECTYPEIND type="CHAR">XX</RECTYPEIND>

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

</PP_TEST_P>

</Test>

</ns0:SP_DB></b>

The error I am getting is:

<b><i>2007-08-20 09:44:05 Error Unable to execute statement for table or stored procedure. 'PP_TEST_P' (Structure 'Test') due to java.sql.SQLException: ERROR: Invalid XML document format for stored procedure: 'type="<SQL-type>"' attribute is missing for element 'table' (Setting a SQL-type (e.g. INTEGER, CHAR, DATE etc.) is mandatory !)

2007-08-20 09:44:05 Error JDBC message processing failed; reason Error processing request in sax parser: Error when executing statement for table/stored proc. 'PP_TEST_P' (structure 'Test'): java.sql.SQLException: ERROR: Invalid XML document format for stored procedure: 'type="<SQL-type>"' attribute is missing for element 'table' (Setting a SQL-type (e.g. INTEGER, CHAR, DATE etc.) is mandatory !)

2007-08-20 09:44:05 Error MP: Exception caught with 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: ERROR: Invalid XML document format for stored procedure: 'type="<SQL-type>"' attribute is missing for element 'table' (Setting a SQL-type (e.g. INTEGER, CHAR, DATE etc.) is mandatory !)

2007-08-20 09:44:05 Error Exception caught by adapter framework: null

2007-08-20 09:44:05 Error Delivery of the message to the application using connection JDBC_http://sap.com/xi/XI/System failed, due to: 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: ERROR: Invalid XML document format for stored procedure: 'type="<SQL-type>"' attribute is missing for element 'table' (Setting a SQL-type (e.g. INTEGER, CHAR, DATE etc.) is mandatory !).</i></b>

Pls advice..

XIer

Message was edited by:

XIer

[Former Member]

It looks to me like you need to add an attribute for the element table in the DT, or the attribute field is required and it isn't mapped correctly.

[Former Member]

Hi,

Check your DATA TYPE attributes with the attributes of the column names in the Database table. There is a mismatch between the DT and Table in the database.

<b>Cheers,

*RAJ*</b>