Re: Oracle Newbie: XML Handling in Oracle 9i

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Wed, 29 Jan 2003 22:36:56 -0800
Message-ID: <3E38C808.BF8D8F8B@exesolutions.com>

Larry wrote:

> I'm wondering if any of you have any general thoughts or suggestions
> regarding whether or not one should pass, as an application
> implementation practice, XML documents into Oracle SPs; rather than
> pass/use primitive data types.
>
> Also I have a specific question:
>
> When one passes an XML document, does the DB Engine automatically
> create Dynamic SQL? And if so, what impact, I would imagine there
> would be some(?), is there regarding performance degradation?
>
> Thanks
>
> Larry

It can be done either way. The way chosen depends on what works best in a specific situation. Personally I prefer to keep all SQL in the database and pass nothing but parameters.

That said ... nothing in the database automatically creates anything ... especially not SQL. You either pass it in as a VARCHAR2 or CLOB or, as I prefer, write it in database packages.

Daniel Morgan Received on Thu Jan 30 2003 - 00:36:56 CST