Re: Oracle XML display problem

Matt wrote:

> I'm running Oracle 10g server and trying to implement a XML database.
> Whenever I try selecting my sample documents as part of a query, it
> will only pull the first two rows of the XML data. How do I change
> this print size for the query? Thanks in advance....

Likely it is pulling it all but you just aren't seeing it.

Try this:

SQL> set long 100000

SQL> ...your query here...

If that works then it is just the default size of the long datatype as displayed. Otherwise ... post your SQL.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)