| Oracle, SQL Task, and XML | Oracle, SQL Task, and XML 2005-06-15 - By Anderson, Rob (Global Trade)
The sql task does not support all the same stuff that you might find in sqlplus
. The query is run via jdbc driver. This may be the cause of the descrepency
between what you see using ant and what you see using sqlplus.
-Rob A
> -----Original Message-----
> From: Renick, Garrel [mailto:garrel@(protected)]
> Sent: Wednesday, June 15, 2005 7:33 AM
> To: user@(protected)
> 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@(protected) 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@(protected)
> For additional commands, e-mail: user-help@(protected)
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@(protected)
For additional commands, e-mail: user-help@(protected)
|
|
 |
