Re: XML in Oracle 8i

From: dmz17 <dmz17_at_nospam.nowhere.com>
Date: Mon, 04 Nov 2002 21:59:41 +0100
Message-ID: <pan.2002.11.04.20.59.40.949991@nospam.nowhere.com>

On Mon, 04 Nov 2002 19:28:19 +0000, Jeff Rimland wrote:

> Hello,
>
> I'm trying to get our Oracle 8i database to return records in XML format.
> The Oracle XML-SQL Utility might do the job with Java code, but I'm trying
> to do this through VB using OLE DB.
>
> Essentially, I want to execute a SELECT statement and get a string
> containing an XML document in return.
>
> Is this possible in Oracle 8i?
>
> Thanks,
> Jeff

I think it would involve a little work:

You have Java built into 8i, so write a stored procedure that does the job for you and returns the XML.

You could also use your normal VM routines to get a resultset and write the XML yourself. Probably slightly more ineffective.

In 9i, of course, you have XML DB built right in.

Cheers,

dmz17 Received on Mon Nov 04 2002 - 14:59:41 CST