Re: XML problem on 8i

From: Nuno Souto <nsouto_at_optushome.com.au>
Date: 12 Dec 2002 18:37:55 -0800
Message-ID: <dd5cc559.0212121837.4b520c8c@posting.google.com>

"pmatt69" <pmatt69_at_hotmail.com> wrote in message news:<uvhhn821saha38_at_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_at_optusnet.com.au.nospam Received on Thu Dec 12 2002 - 20:37:55 CST