Re: Oracle Newbie: XML Handling in Oracle 9i

Daniel,

I think I understand: When I pass a CLOB into Oracle (which consists of XML) Oracle DOES NOT create Dynamic SQL.

If this is the case, not that I disagree or disbelieve, can you (or anyone) please explain, or point me to a reference which explains in detail, how the Java packages perform UPDATE, DELETE and INSERT operations when XML is passed in as a CLOB, since the DB Engine doesn't create Dynamic SQL?

(This is an important architectural issue which must be decided based upon objective - external - information.)

Thank you for your assistance.

Regards,

Larry

hlar2_at_hotmail.com (Larry) wrote in message news:<a88826f4.0301291646.77e70069_at_posting.google.com>...
> 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
Received on Thu Jan 30 2003 - 18:19:52 CST