Skip to Content
avatar image
Former Member

Structure for Stored Procedure Call

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=" "' attribute is missing for element 'table' (Setting a SQL-type (e.g. INTEGER, CHAR, DATE etc.) is mandatory !).

Pls advice..

XIer

Message was edited by:

XIer

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Aug 20, 2007 at 05:30 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

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