I have downloaded and installed SOAP_API that Tim wrote and posted on ORACLE-BASE. I have followed all of his examples code using the SOAP_API code set. I have created code that uses the SOAP_API just like in the examples, but with my data. I am also connecting to an external service. I have added code that accommodates that too. When I test my function, I am getting this error.
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00225: end-element tag "body" does not match start-element tag "HR"
Error at line 1
ORA-06512: at "SYS.XMLTYPE", line 60
ORA-06512: at "SYS.SOAP_API", line 144
ORA-06512: at "BANINST1.COLLEGENET_SSO",
Any idea? Thanks.
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Did I mention that the web service is external. I am trying to make calls to that service using the functions and procedures in that SOAP_API package. I know that it is not completing the xml contents, but where. The SOAP_API uses UTL_HTTP, I can not trace it because it is Oracle's code. Do you think it is a firewall problem, that the port is not open? Is there any way for me to test that idea, using PL/SQL?
Firewall's don't appear to be the problem at all.
The error indicates you are retrieving data.
the problem is the data itself is bad
to see the error you will need to look at the raw xml text rather than the resulting xmltype because parsing into the xmltype is where the error is occuring
Right now you have a line like this I assume...
UTL_HTTP.read_text(l_http_
immediately after that line add this...
DBMS_OUTPUT.PUT_LINE(l_env
and then capture that output, you should see bad xml structured something like I have shown above with the mismatched <HR> and </body> tags
Business Accounts
Answer for Membership
by: sdstuberPosted on 2009-10-31 at 06:55:21ID: 25709787
based on the error it looks like your xml content isn't valid
you have something like this...
<HR>
<stuff></stuff>
<otherstuff></otherstuff>
</body>