Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How is a CLOB stored when XML is created from query?

Re: How is a CLOB stored when XML is created from query?

From: g3000 <carlton_gregory_at_yahoo.com>
Date: 20 Jul 2005 13:40:14 -0700
Message-ID: <1121892014.522890.23850@f14g2000cwb.googlegroups.com> 





i created the the xml as a clob and use a java stored procedure to
write it to a file on the file system.



If the table the query was run against has a column that is a clob its
data is not returne in the final XML doc.



im on 9.2.0.6 on Windows using dbms_xmlquery.getXml() to pass my query
Received on Wed Jul 20 2005 - 15:40:14 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US