Re: XML problem on 8i

#1

"pmatt69" <pmatt69 (AT) hotmail (DOT) com> wrote

Quote:

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 (DOT) com.au.nospam

#2

Fri, 13 Dec 2002 15:30:28 -0500, pmatt69 said (and I quote):

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?

Quote:

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 (DOT) com.au.nospam

#3

Nuno Souto <nsouto (AT) optushome (DOT) com.au.nospam> writes:

Quote:

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.

Are you serious? The script is in tcsh? I didn't think there was

anyone on the planet who still writes scripts in tcsh - in fact, even
back in the late 80's when I used tcsh as my login shell, it was well
known to be a crappy shell for scripting! Then again, I'm even
serprised that Oracle still uses csh for some of their scripts rather
than just sticking to Korn, Bourne/Bourne Again shells.

Tim

--
Tim Cross
The e-mail address on this message is FALSE (obviously!). My real e-mail is
to a company in Australia called rapttech and my login is tcross - if you
really need to send mail, you should be able to work it out!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: XML problem on 8i

comp.databases.oracle.misc comp.databases.oracle.misc

Re: XML problem on 8i - 12-12-2002 , 08:37 PM

Re: XML problem on 8i - 12-14-2002 , 06:12 AM

Re: XML problem on 8i - 12-14-2002 , 07:03 PM