Database Software

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 size restriction

393679Jun 4 2003 — edited Jun 5 2003

I created a table type of XMLTYPE. I then do a SELECT XMLEMENT(.....) INTO typTBL(nRecCount). I'm running onto ORA-22814: attribute or element value is larger than specified in type
ORA-06512: at "RDSTEST.GENERATE_ACTIVE_TRADE_XML", line 170
ORA-06512: at line 1

So I figured I can redef my table type to CLOB. However, I lose all my XML formatting (I see "&lt" instead of "<").

Is there anyway around this size restriction?

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 3 2003

Added on Jun 4 2003

#performance-availability, #xml-db

2 comments

370 views