Skip to Content
0
Former Member
Jul 10, 2014 at 02:08 AM

JDBC Receiver adapter Stored procedure

565 Views

We are using stored procedure to insert/update the data into SQL database, for this I define data type as below

But the JDBC call is failing with error " com.sap.engine.interfaces.messaging.api.exception.MessagingException:
Error processing request in sax parser: Error when executing statement for
table/stored proc. 'insert_IDOCRec' (structure 'STATEMENT'):
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 !)"

Can you please help me why the JDBC call is failing with the above error.


Attachments

Untitled2.png (36.0 kB)