Skip to Content

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

JDBC adapter configuration problem while design

Hi,

I am connecting SAP TO THIRD PARTY using RFC and JDBC,which is using a stored procedure.

I have mapped in such a way that

table = is mapped with the stored procedure name.

isinput = true.

type = char.

But If i look into the monitor its showing a problem with DATATYPE,which i have mentioned is char.The metioned below is log.

Can any one help me,what changes I have to make.

com.sap.aii.af.ra.ms.api.DeliveryException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'STORED_PROCEDURE_NAME' (structure 'Statement'): java.sql.SQLException: ERROR: Invalid XML document format for stored procedure: 'type="<SQL-type>"' attribute is missing for element 'MaterialNumber' (Setting a SQL-type (e.g. INTEGER, CHAR, DATE etc.) is mandatory !)</SAP:AdditionalText>

<SAP:ApplicationFaultMessage namespace="" />

With Regards,

KishoreJ.

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