This content has been marked as final. Show 6 replies
rebuilding took effect, but i can't still get xml field from ORDImage
XMLType xml = media.getMetadata("EXIF"); -->it returns empty XMLType array
anyone knows how to do that?
Edited by: dejaraczo on 2011-02-09 02:39
i can extract this field using following select, but i thought Java API can also do that
select tab.extract('//DateTime/text()').getStringVal() datetime from ordimagetable p, TABLE(p.image.getMetadata('exif')) tab
someone knows how to use java XMLType for that?
Edited by: dejaraczo on 2011-02-09 04:53
Your usage of getMetadata in Java should work.
If I understand correctly, it now compiles, but you get an empty XMLType array as a result?
What database version are you using?
Edited by: mannamal on Feb 11, 2011 9:57 AM
yep, it compiles but i'm giving empty XMLType array
Oracle Database 11g
Can you raise a service request with Oracle Support? They can re-create the exact situation and identify the problem.
A couple more things to try:
- Use ojdbc5.jar
- Take a look at http://www.oracle.com/technology/sample_code/tech/java/codesnippet/jsp/xmltype/index.html and make sure your code is indeed importing: