Re: Schma for XML Type in Oracle

sk wrote:
> We are thinking of putting xml document in oracle's xml type field as a
> metadata for the system, so that we can
> have flexibility on the metadata structure.
>
> How the schema of this item can be defined for a particular record so that
> when I insert or update the xml it can also be validated?
>
> SK

And your Oracle version is?

In my opinion storing XML in a database is a bad idea. Storing metadata as XML sounds even worse. What is the business case? Is this, by any chance, metadata equivalent to that retrievable with the built-in dbms_metadata package? If so it already has a GET_XML procedure.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org