Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Newbie: XML Handling in Oracle 9i

Re: Oracle Newbie: XML Handling in Oracle 9i

From: Larry <hlar2_at_hotmail.com>
Date: 31 Jan 2003 00:27:07 -0800
Message-ID: <a88826f4.0301310027.5f7a255e@posting.google.com>


Basically, the question I'm faced with answering is:

Is it poor practice, or generally thought to be inefficient, to pass XML (clobs) into SPs versus simple parameters into SPs?

Also, if it is acceptable to use the approach of passing XML docs, is it best practice to use an XML Schema as well?

----Start High Level----

Generally speaking, in n-tier design, the middle-tier components, as well as stored procedures, change anytime a new field which must be populated, is added to a DB table.

However, if I use XML docs or strings representing XML docs, passed into SPs as clobs, I can easily add new parameters to my XML document and create a single SP, for example, called "UpdateSP" to handle updates.

----End High Level----

I believe Oracle uses Java packages to assist in the execution of XML docs, and I'm wondering if operating in the above scenario is recommended, discouraged, or simply a matter of preference.

A newbie like myself might easily think that Oracle receiving XML in a clob would mean, automatically, that it would generate Dynamic SQL under the covers, in order to execute the interpreted statement, or statements.

Additionally, a someone like myself easily consider this approach to be inefficient, compared to simply passing in a set of parameters, even in large numbers.

Please forgive my inability to correctly pose this very important question in a way which makes sense. I appreciate, very much, your level of granularity and your patience.

Regards,

Larry Received on Fri Jan 31 2003 - 02:27:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US