on 11-20-2008 2:36 PM
Hello,
I have some scenarios from WS to stored procedure in Oracle data base.
Some off them work correctly but in one off them I have a mapping problem.
These scenario looks like the others (only the table name and the name off one field in oracle stored procedure are different) but I have a mapping problem:
Cannot produce target element /ns0:unlock_pl_SP_MT/STATEMENTNAME. Check xml instance is valid for source xsd and target-field mapping fulfills requirements of target xsd
I'll be happy to hear any ideas how I can investigate this problem.
Elad
Hello,
When I checked this web service from web service navigator I received error.
When I checked the same web service from external toll they work properly.
Elad
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
There might be a restriction/ condition imposed on the target element /ns0:unlock_pl_SP_MT/STATEMENTNAME which your source xml is not able to meet. Please check for the data/ structure of your source message and also make sure that your mapping is made accordingly.
Regards,
Abhishek.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
check ur mapping for target element /ns0:unlock_pl_SP_MT/STATEMENTNAME.
else give us the source and target structure along with mapping for more help. Use the test tab to test the mapping with sample data.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Thank you for your message.
This is the source:
<?xml version="1.0" encoding="UTF-8"?>
<ns0:unlock_pl_WS_MT xmlns:ns0="com:netafim:pricing:unlock_pl">
<unlock_pl/>
</ns0:unlock_pl_WS_MT>
This is the target:
<?xml version="1.0" encoding="UTF-8"?>
<ns0:unlock_pl_SP_MT xmlns:ns0="com:netafim:pricing:unlock_pl"><STATEMENTNAME><unlock_pl action="EXECUTE"><table>UNLOCK_PL</table></unlock_pl><E_PLNO type="CHAR" isInput="1"></E_PLNO><E_STATUS type="CHAR" isOutput="1" isInput="1"></E_STATUS></STATEMENTNAME></ns0:unlock_pl_SP_MT>
Thank you
Elad
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
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.