JDBC adapter configuration problem while design
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="" />