Web Development·12,146 discussions

XML and Oracle

Locked

Is anybody using XML inside a Oracle Database?
How did you implement it, and why did you do it that way?

Thanks,

Paul R. Johnson

Topic

XML and Oracle

In reply to XML and Oracle

Hi Paul,
Though i have not implemented it yet but i am exploring the possiblity of using xml with oracle.

It seems oracle has three packages which support xml integration. they are-
DBXML
Format SQL query results as XML
DBDOM
The most common and useful parts of the DOM API in PL/SQL
DBXSL
XSL transformations in PLSQL

And as for why do it xml way, the answer is that is the best way to do.

xml formatted document is the easiest for a new eye and in my case my invoicegenerator module has to provide output to a file which is to be used by a finance guy, who is not that technical.

An xml formatted document is very easy for him to comprehend

i hope it hepls u

Pawan

XML and Oracle

In reply to XML and Oracle

The question was auto-closed by TechRepublic

XML and Oracle

In reply to XML and Oracle

Here’s some really quick information for you.
I got this from a book; “XML A Manager’s Guide” by Kevin Dick. It’s marked as a $30 book so you should be able to find it for less. Hope this helps.
Some benefits:
-Portable user profile definition and flexible content customization. Web Pages.
-Easy format translation and document assembly. Information Aggregation
-Ability to interpret configuration across products. Software Bill of Materials
-Compatability of development and analysis tools across software implementations. Configuratio and Logging Files
-Faster development through access to standard formatiing infrastructure. Distributed Protocols

This is a great book was well layed out and is easy reading. I used it to get into XML and keep going back.

XML and Oracle

In reply to XML and Oracle

The question was auto-closed by TechRepublic

XML and Oracle

In reply to XML and Oracle

This question was auto closed due to inactivity

[Author]

Replies