I've encountered the error asked in posts https://community.oracle.com/message/12420625#12420625 and https://community.oracle.com/message/2311131#2311131 which asked why the following error was produced when a schema was attempted to be registered:
dbms_xmlschema.registerschema(schemaurl => p_SchemaURL
,schemadoc => p_TestXSDinClob
,gentypes => false -- generate object types
,genbean => false -- no java beans
,gentables => false -- generate object tables
--CSID => nls_charset_id('AL32UTF8'));
--,force => true
);
ERROR at line 1:
ORA-31038: Invalid integer value: "102400"
ORA-06512: на "XDB.DBMS_XMLSCHEMA_INT", line 72
ORA-06512: на "XDB.DBMS_XMLSCHEMA", line 33
The answer given was that need to annotate the element with xdb:SQLType="CLOB". I've try it
<xs:simpleType name="Max100KBinary" xdb:SQLType="BLOB">
<xs:restriction base="xs:base64Binary">
<xs:minLength value="1"/>
<xs:maxLength value="102400"/>
</xs:restriction>
</xs:simpleType>
but error is the same.
Is there a way to keep the maxLength restriction (not 32767) and register schema?