Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: XML problem on 8i
"Nuno Souto" <nsouto_at_optushome.com.au.nospam> wrote in message
news:3dfb22fc$0$29731$afc38c87_at_news.optusnet.com.au...
> Fri, 13 Dec 2002 15:30:28 -0500, pmatt69 said (and I quote):
> >
> > Yep, I downloaded the newest one from Oracle and installed that into a
> > different schema. It is better, now I get this:
> >
> > XMLGEN.GETXML('SELECTDUMMYFROMDUAL')
>
> --------------------------------------------------------------------------
--Received on Mon Dec 16 2002 - 11:25:37 CST
> > ----
> > <?xml version = '1.0'?>
> > <ROWSET>
> > <ROW num="1">
> > <DUMMY>X</DUMMY>
> > </RO
> >
> > It does this for every query, almost like it just gives up :-) I
imagine I
> > will find a solution to this at some point.
>
>
> It's just getting truncated. Check the length of varchar or long output
> setting in SQL*Plus. I can't remember what the "set" variable name is,
> can any1 help here?
>
>
> >
set long n set pages m n is something big enough to hold the xml output, m is something big enough to stop sqlplus from paging on the xml output Thanks for pointing me in the right direction. Matt