Re: data not showing in query result pane

On 6/8/07, Jowers, Tim <tim.jowers@xxxxxxxxxxxxxxxxxxx> 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

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/