Skip to Content

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

JDBC Receiver adapter

scenario is Proxy to JDBC synchronous

i have action atrribute in my structure still got these errors

Error while parsing or executing XML-SQL document: Error processing request in sax parser: No 'action' attribute found in XML document (attribute "action" missing or wrong XML structure)

Error processing request in sax parser: No 'action' attribute found in XML document (attribute "action" missing or wrong XML structure)

Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: No 'action' attribute found in XML document (attribute "action" missing or wrong XML structure)

JDBC Request strcture looking like this

DT_abcd_abcd

Storedprcedure

action (attribute)( I have hard coded as CALL)

table ( stored procedure name)

InParam1 (this is my 1st paramter always value 1, so i hard coded it)

type (Varchar)

InParam2 (2nd parameter always ac, hardoded as well)

type (varchar)

InParam3 (3rd parameter hard coded value)

type (varchar)

Inparam4 (4th parameter - runtime value )

type (varchar)

Inparam5 (5th paramter - runtime value)

type (Varchar)

JDBC Response structure

DT_JDBC_Response

Response

Result

Former Member
Former Member replied

Hi

You need to use action = Execute instead of CALL

Refer formats

http://help.sap.com/saphelp_nw70/helpdata/EN/2e/96fd3f2d14e869e10000000a155106/content.htm

Thanks

Gaurav

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question