*BUT* : You seem to have a full XML document as the payload. If you were to convert the escaped characters this would result in an invalid document. You can't have an XML definition with an XML document. It will result in this.

Do you I shouldnt check for anything here, If there are records it will return the full xml and if there are no records as u can see in the above xml, there is a attribute RecordCount=0, along with the returned xml.

I can pass this xml as it is to the calling program and they can decide what to do.

- Altered the two URLs, as I mentioned in my previous post. The ones you used were wrong because you included an extra "/" on the end of the URLs. The fault returned by the web service said it didn't like the trailing "/", so I removed them from the URLs.

- I added the call to DBMS_XMLGEN.convert before returning the value, so the XML is displayed properly, rather than in an encoded state.

You said you wanted an example of your web service call working. That's it.

- Altered the two URLs, as I mentioned in my previous post. The ones you used were wrong because you included an extra "/" on the end of the URLs. The fault returned by the web service said it didn't like the trailing "/", so I removed them from the URLs.

- I added the call to DBMS_XMLGEN.convert before returning the value, so the XML is displayed properly, rather than in an encoded state.

You said you wanted an example of your web service call working. That's it.

Cheers

Tim...

But.. Do you have edit function from package soap_api??I added your code (DBMS_XMLGEN.convert ) and i have always error