Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed.news2me.com!canoe.uoregon.edu!logbridge.uoregon.edu!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: nsouto@optushome.com.au (Nuno Souto)
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server
Subject: Re: XML problem on 8i
Date: 12 Dec 2002 18:37:55 -0800
Organization: http://groups.google.com/
Lines: 29
Message-ID: <dd5cc559.0212121837.4b520c8c@posting.google.com>
References: <uvhhn821saha38@corp.supernews.com>
NNTP-Posting-Host: 211.28.96.9
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1039747075 21987 127.0.0.1 (13 Dec 2002 02:37:55 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 13 Dec 2002 02:37:55 GMT
Xref: newsfeed1.easynews.com comp.databases.oracle.misc:90515 comp.databases.oracle.server:169561
X-Received-Date: Thu, 12 Dec 2002 19:50:42 MST (news.easynews.com)

"pmatt69" <pmatt69@hotmail.com> wrote in message news:<uvhhn821saha38@corp.supernews.com>...
> 
> select xmlgen.getxml('select group# from v$logfile') from dual;
> 
> This is what I get:
> 
> <?xml version = '1.0'?>
> <ERROR>java.lang.NullPointerException</ERROR>
> 


Unfortunately in that particular version the
getxml function is a bit, how shall I put it, "thick"?...

There are some later versions that you can install that fix
this problem.

Alternatively:

Try with 'select dummy from dual' and it should work.
The difference is the darn thing can't handle special
characters inside your string.  Such as '#' and '$'.  You
may have to use a view-on-a-view to be able to use that 
statement on that view.

HTH
Cheers
Nuno Souto
nsouto@optusnet.com.au.nospam