Re: XML problem on 8i

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')
> ----------------------------------------------------------------------------
> ----
> <?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?

>
> BTW - I could throttle the geniuses at Oracle who decided to make xdkload a
> tcsh script. Our stripped down server was missing that shell. No big deal
> to add it, but why not script in a shell you know everyone has.
>

Heh! Lovely, eh?

-- 
Cheers
Nuno Souto
nsouto_at_optusnet.com.au.nospam