Re: [Squirrel-sql-users] data not showing in query result pane

[Robert M. <rob...@gm...>]

On 6/8/07, Jowers, Tim <tim...@ve...> wrote:
> I query a table with some XML input and XML output in it but do not get the
> text from the database. I get something like:
>
> <Unknown(2,007)>
>
>
>
> Is there a way to change Squirrel to show the actual data?

Sorry, there is no support for the SQL-2003 XML type yet.  If you are
using Oracle, then for now you can use
XMLSERIALIZE(CONTENT(<xmltype>). For example:

create table XMLTable (doc_id number, xml_data XMLType);

insert into XMLTable values (1,
XMLType('<FAQ-LIST><QUESTION><QUERY>Question 1</QUERY><RESPONSE>Answer
goes here.</RESPONSE></QUESTION></FAQ-LIST>'));

-- yields (Unknown 2,007)
SELECT xml_data
FROM XMLTable

-- yields  '<FAQ-LIST><QUESTION><QUERY>Question 1...'
select XMLSERIALIZE(CONTENT xml_data)
from   XMLTable


Rob