on 10-08-2008 6:27 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.