Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

XMLTYPE, BLOB, CLOB and SIMPLE TABLE

458694Oct 6 2005 — edited Oct 21 2005

Hi,

In my project we have a requirements to store the XML messgaes in the database. I would like to know should I store it in the XMLTYPE format or in CLOB, BLOB format or should I parse the XML and store in the separate columns.

I would like to know what would be an impact on the performance if I use XMLTYPE.

Is there any constraints on the size of XML if I use XMLTYPE.

Thanks in advance.

Thanks & Regards,
Chintan

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 18 2005

Added on Oct 6 2005

#general-database-discussions

4 comments

532 views