on 12-08-2011 3:49 PM
Anyone has success reading Oracle data type XMLTYPE.
select all query returns all other columns but the XMLTYPE column is blank
MII - 12.1.9
Thanks
Ajay
Edited by: Ajay Malempati on Dec 8, 2011 10:50 AM
Have you tried doing a TO_CHAR(XMLColumn) AS StringXMLColumn on the column to see if string conversion does the trick?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Wow ..
Thank you for the tip Pedro .. Aliasing the table name worked
I was trying ..
SELECT
TABLENAME.YOURXMLCOLUMN.extract('*').getStringVal() as myXMLColumn
FROM
TABLENAME
Got the following error.
Error is java.sql.SQLException: ORA-00904: "TABLENAME"."YOURXMLCOLUMN"."EXTRACT": invalid identifier ..
Tip: Alias table name in the query.
Thank you
Ajay.
User | Count |
---|---|
10 | |
5 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.