cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC Receiver adapter

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

These blogs may help you:

Best Regards,

Pedro Nunes

Former Member
0 Kudos

check this..

action = EXECUTE instead of CALL.

Edited by: Anand on Oct 8, 2008 7:50 PM