we no longer get results for the XML but as we select more columns we see that results are returned (i.e. the non XML containing columns can be visualised).
And I wouldn't think that there's a difference between what you get back in XMLType and what you get back as CLOB, since the default underlying storage type for XMLType is CLOB. The other storage type is schema-generated.
I-Lin Kuo, Ann Arbor, MI Macromedia Certified ColdFusion 5.0 Advanced Developer Sun Certified Java 2 Programmer Ann Arbor Java Users Group (http://www.aajug.org)
_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
