Toad World® Forums

Oracle xmltype error


#1

Oracle xmltype error


#2

What are the versions of Toad, the database, and the Oracle client? Those all
make a big difference in dealing with XMLTYPE information.

Since you’re using binary XML, your database is definitely 11.x (I forget
whether that came in with 11.1 or 11.2). Is the Oracle client that you’re using
for that connection at least as current as the database?

And what do you want to see in Toad? Binary XML turned back into character data,
actual binary representations, or what?

Developers: does Toad support binary XML storage yet?

– jim


#3

Just upgraded TOAD to 10.6. Until today used 10.1. At the ODTUG meeting this
year I asked the TOAD guys why Toad reported XMLTYPE data stored as binary xml
as CLOB when you ask for the table script in the schema browser. Was told it
was a known problem and to update TOAD - the problem was fixed. Well that is
true. The schema browser now reports the correct storage type. I hoped the
problem mention at the beginning of this thread had also been addressed -
apparently not.

Database is 11.2. Oracle client is 11.1.0.

I also use SQL Developer and it shows the xml as character data. The hope Toad
can do that too because Toad’s xml interface is superior when it works.

–rodney

Hudson, James - DNR said the following on 11/8/2010 2:18 PM:

What are the versions of Toad, the database, and the Oracle client? Those
all make a big difference in dealing with XMLTYPE information.

 

Since you're using binary XML, your database is definitely 11.x (I forget
whether that came in with 11.1 or 11.2). Is the Oracle client that you're
using for that connection at least as current as the database?

 

And what do you want to see in Toad? Binary XML turned back into character
data, actual binary representations, or what?

 

Developers: does Toad support binary XML storage yet?

 

-- jim