Try
SELECT XMLELEMENT("Document").getStringVal() FROM [EMAIL PROTECTED]
where
rownum<10;
If your XML is larger than 4000 characters you may want to try
SELECT XMLELEMENT("Document").getClobVal() FROM [EMAIL PROTECTED]
where
rownum<10;
-Original Message-
From: Renick, Garrel [mailto:[EM
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:[EMAIL PR
