This content has been marked as final. Show 3 replies
What's the database version (select * from v$version)?
Could you post an example of the XML content in ORIMAGE_METADATA column?
Assuming the XMLType column is based on the XML schema for ORDImage Attributes, you can use this :1 person found this helpful
SELECT p.pk_guid , xmlcast( xmlquery( 'declare default element namespace "http://xmlns.oracle.com/ord/meta/ordimage"; (: :) /ordImageAttributes/width' passing p.orimage_metadata returning content ) as number ) as photo_width FROM photo p ;
The sentence is right and works fine.