cancel
Showing results for 
Search instead for 
Did you mean: 

problem with web service to stored procedure in Oracle data base

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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

former_member200962
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

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.

Former Member
0 Kudos

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