SupportSupport

I attempted to search for this problem in the current threads that involve viewing the Oracle XMLType so I believe I've done everything that's helped others in the past. I've added both the xdb.jar and xmlparserv2.jar libraries to the Device Manager. Before I added these two libraries I was getting the opaque version of the XML data, after installing the libraries I get nothing but null highlighted in red with the error "Error getting value for: 240/1: java.sql.SQLException: Only LOB or thin Storage is supported in Thin XMLType".

I've attached an image of the Device Manager screen and of the SQLException being displayed when I attempt to access the XML data. I'm attempting to get my team to move to DBViz and ditch Toad so it would be great to get this going. I believe this is the last hurdle before I can show them that this wonderful tool does everything that Toad does and more.

Thanks in advance for your time. Please let me know if you need additional information and/or inform me that my "search-fu" is lacking and I'll renew my search of past threads.

UPDATE: It looks as if my google-fu is what was lacking. It looks like there's an issue using the thin client with schema based XMLType versus non-schema based. There seems to be a way to make the schema based XMLType work with the thin client though (http://forums.oracle.com/forums/thread.jspa?threadID=417030). I don't know if this is true or if it is that DBViz uses this method to handle schema based XMLTypes? Not sure if any DBViz developers patrol these boards...hope so. Thanks again for any insight.

Edited by: dshmif on Nov 30, 2010 11:17 PM

Edited by: dshmif on Nov 30, 2010 11:22 PM

Thanks so much for responding.

The contents of the Connection Message Box:
"Oracle
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
Oracle JDBC driver
10.2.0.3.0"

DDL to register a schema:
BEGIN
dbms_xmlschema.registerSchema(
schemaurl => 'http://toms.odc.vzwcorp.com/toms_X4.xsd',
schemadoc => '<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified"
xmlns:xdb= "http://xmlns.oracle.com/xdb" version="1.0">
<xs:element name="your_root_element" xdb:defaultTable="your_table_name">
...
</xs:element>
</xs:schema>
');
END;

Hopefully that comes out. Thanks again for the help.

I'm having this same situation. If I use getClobVal, I get the correct data from my XMLTYPE column. Otherwise, using a straight SELECT, I get part of the XML string, but it has high ASCII characters embedded throughout. See attached picture. Any suggestions?

Thanks,
Sammy