Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
PL/SQL XML Programming
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Nov 30, 2012 1:27 AM by
extracting parameter in XML data when left tag is associated with Variable
Nov 29, 2012 8:56 PM
Help needed into extract value for release field. Left Tag is associated with release_Id value for different release fields values of MD and AL.
case a) <release_id="50620">MD</release>
case b) <release_id="50621">AL</release>
case c) If release field is null, tags wont be created.
The following sql function did not work. could you please suggest me. if you need any further info, please let me know.
select extractvalue(CONVERT_BLOB_TO_XMLTYPE(xml), '/cutom-data/release')
This content has been marked as final.
Show 1 reply
Re: extracting parameter in XML data when left tag is associated with Variable
Nov 30, 2012 1:27 AM
in response to
Database version please?
What error do you get?
This is not wellformed XML :
Are you sure this is what you have?
Please give a valid sample XML document (with one root), explain the output you require, and then we'll be able to provide you with a relevant solution.