Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How do i prevent getting a xml declaration in the xml response

807404Oct 22 2010 — edited Oct 26 2010
Hi,
I am using a soap call to access a webservice via plsql.
The xml response from the webservice starts as follows
<?xml version='1.0' encoding='UTF-8'?><soapenv:Envelope xmlns:soapenv="http://www.w3.org/2003/05/soap-envelope">..............


I want to find ways to
1. either prevent the xml tag <?xml version='1.0' encoding='UTF-8'?> from being returned in the response.
2. or somehow convert the entire response to a string and remove it by substr (not sure about this)

The issue i am facing is that when i run a xmltype.extract on the xml to get a particular node i am getting the
ORA-31013: Invalid XPATH expression

when i remove the tag from the response (using hardcoded values) i get the right values back.

Any suggestions are welcome.
Regards
kpillai

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 23 2010
Added on Oct 22 2010
#pl-sql-xml-programming, #plsql, #xml
5 comments
552 views