How to save XML document in oracle database

i want to save a dynamically generated XML document in the o开发者_如何转开发racle db using c#.net can anyone tell me the way to get this done

---

You didn't mention your Oracle version. (You should always provide the Oracle version and edition and the OS and OS version.)

This is not a simple question. There are multiple options.

You could create a table with an XMLTYPE column. Even with the XMLTYPE column, there are multiple options available. XML may be stored using CLOB storage, BINARY XML storage, or into an Object Relational model. Within the BINARY XML option, you could use BASICFILES or SECUREFILES, and have the option to enable compression.

The correct type of storage will depend on how you intend to use/search the data, but it a pretty complicated question that will require knowledge of your application system.

If you have no search/retrieval requirements beyond simple primary key lookups, then just use an XMLTYPE column with CLOB storage, and forget it. For anything beyond that, it's a non-trivial question.

Hope that helps,

-Mark

---

XML is just text. Try to insert in some CLOB or NCLOB field in your database?