Oracle-L: RE: Using XML in the dba

From: Magaliff, Bill <Bill.Magaliff_at_lendware.com>
Date: Fri, 05 Apr 2002 05:33:25 -0800
Message-ID: <F001.0043CA44.20020405053325@fatcity.com>

thanks - don't need from PL/SQL, just regular SQL calls that will return tagged XML

-----Original Message-----
Sent: Fri, April 05, 2002 8:05 AM
To: 'ORACLE-L_at_fatcity.com'
Cc: 'Bill.Magaliff_at_lendware.com'

Bill,

If you will be using the XML from PL/SQL calls, you will probably need the Oracle XDK for PL/SQL packages installed. There are several versions available. I actually installed the 9.0.2.0.0D version in my 8172 database and it seemed to work ok. The developer I was working with tried it, but dropped it for lack of time and interest. I created a separated Oracle account for the packages and installed the stuff there just so I could drop it easily. The packages are available on TechNet.

Hope this helps.

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
Sent: Thursday, April 04, 2002 5:56 PM
To: Multiple recipients of list ORACLE-L

I need to set up my 8.1.7.2 db to produce XML output from SQL queries. Referring to the Oracle XML Handbook (Oracle press) I think we're interesed in the XSQL . . . need to know how to prepare the db/client for this.

I installed the JServer manually (via the initjvm.sql script) and have a 20Mb Java pool on the server (NT 40 SP6a)

I see the client needs JDK 1.1.6 or higher.

Is there anything else I need to do on the server? The developer will be accessing via Net8 (I think) . . . .

not even sure what other questions I need to ask.

Thanks, all

Bill Magaliff
Framework, Inc.
914-631-2322

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Magaliff, Bill
INET: Bill.Magaliff_at_lendware.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Magaliff, Bill
INET: Bill.Magaliff_at_lendware.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------