Re: XML problem on 8i

From: pmatt69 <pmatt69_at_hotmail.com>
Date: Fri, 13 Dec 2002 15:30:28 -0500
Message-ID: <uvkgr0s3hvc62d@corp.supernews.com>

"Nuno Souto" <nsouto_at_optushome.com.au> wrote in message news:dd5cc559.0212121837.4b520c8c_at_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

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.

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. Received on Fri Dec 13 2002 - 14:30:28 CST