Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Newbie: XML Handling in Oracle 9i
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