Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-00910 when insert large xml from resource_view to structured table

64982Dec 14 2009 — edited Dec 15 2009
Dear all,

I've got a problem when insert the xml data which node value > 4000 char.

I've create a XML schema when table which reference to this schema, when I try to insert the xml from resource_view which the <content> value > 4000 characters, then following messeage appeared:

ORA-00910: specified length too long for its datatype

P.S. if the value < 4000 chars, it's fine.

here is the part of the .xsd fiel:

<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified">
<xs:element name="root">
<xs:complexType>
<xs:sequence>
<xs:element ref="item"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="item">
<xs:complexType>
<xs:sequence>
<xs:element ref="content"/>
</xs:sequence>
<xs:attribute name="create_time" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="content" type="xs:string"/>
</xs:schema>

Is it because the type "string" does not support more then 4000 characters? it yes, how can I fixed it? As I'm really newbee of XMLDB.

Thanks and Regards
Ray

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 12 2010
Added on Dec 14 2009
#performance-availability, #xml-db
5 comments
1,959 views