posted 13 years ago
Hello there
So I have migrated a web service from oas10 to weblogic. This has caused a change in the xml returned by that web service, and the old way of converting the return xml to useable form no longer works.
I have some pl sql code (I did not write that code, which is why I am having some trouble), that would take the xml from the web service and convert it to useable form. The line that does this operation:
This would take xml that looked like this (I had to make all & gt; and & lt; to >t and <t, otherwise they would be converted to < or > - I hope this is not too confusing):
and convert it to this:
As you can see it just took the stuff in the middle that used gt's and lt's and converts it to > and < and returns it as a nice little bit of readable and parseable xml.
Now with the change to wbelogic, before the conversion, the xml looks like this (again had to use above to make gt and lt not turn into actual symbols):
And the line to convert it to useable form does not work any longer. The code is stopped dead at that point.
I am not looking for the answer explicitly, I am sure some of the pl sql vets see immediately what needs to be done. Just a point in the right direction to resolve this myself. A few terms to google maybe, or some useful tutorials you know of - that kind of thing. Just some tips to get the ball rolling quicker. I could go the long way and start from the very beginning myself, but it is almost xmas and I want to get this off my plate!
By the way, changing the xml output is not the option I want to pursue, so if that can be avoided that is what I am looking for - just a nice, quick pl sql fix.
Thanks!
ps - right now I am researching dbms_xmlgen.convert and dbms_xmlgen.ENTITY_DECODE - so if that is all i should need to put me on the track to answering this then don;t worry about replying (or reply and say that should get me where I need to be)
True wisdom is in knowing you know nothing - Socrates