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: XML problem on 8i

Re: XML problem on 8i

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Sat, 14 Dec 2002 23:12:08 +1100
Message-ID: <3dfb22fc$0$29731$afc38c87@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')
> ----------------------------------------------------------------------------
> ----
> <?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
Received on Sat Dec 14 2002 - 06:12:08 CST

Original text of this message

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