ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dick, Brian E." <Brian.D...@FMR.com>
Subject RE: Oracle, SQL Task, and XML
Date Thu, 16 Jun 2005 14:23:17 GMT
Try

SELECT XMLELEMENT("Document").getStringVal() FROM some_view@some_server
where
rownum<10;

If your XML is larger than 4000 characters you may want to try

SELECT XMLELEMENT("Document").getClobVal() FROM some_view@some_server
where
rownum<10;


-----Original Message-----
From: Renick, Garrel [mailto:garrel@more.net] 
Sent: Wednesday, June 15, 2005 10:33 AM
To: user@ant.apache.org
Subject: Oracle, SQL Task, and XML 



I'm trying to get an XML result set from an Oracle 9i server using ANT's
SQL task with the Oracle JDBC Thin Driver. I can successfully connect to
the database and issue standard SQL through the ANT SQL task and get the
expected result set. However, if I issue SELECT statements with Oracle's
XML-related functions, the output file for the results contains values
that do not match those returned by Oracle's SQLPlus command line
interpreter. I'm not an Oracle guy, so any insight into what my problem
may be would be appreciated.

Here's my query:

SELECT XMLELEMENT("Document") FROM some_view@some_server where
rownum<10;

Oracle's SQLPlus returns these results:

XMLELEMENT("DOCUMENT")
-------------------------------

<Document></Document>
<Document></Document>
<Document></Document>
<Document></Document>
<Document></Document>
<Document></Document>
<Document></Document>
<Document></Document>
<Document></Document>

9 rows selected.


The same query from ANT's SQL task returns this:

XMLELEMENT("DOCUMENT")
null
null
null
null
null
null
null
null
null

0 rows affected

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org


Mime
View raw message