Skip to Main Content

SQL & PL/SQL

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!

dbms_xmlschema.registerschema, (ORA-31084: error while creating table )..

PeterValencicDec 20 2012 — edited Dec 20 2012
Hello,
I have some problems with dbms_xmlschema.registerschema


My database is: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

My XSD schema is (SEPA pain.002.001.03.xsd) also available on this url: http://code.google.com/p/leontestbed/source/browse/trunk/bc2/sample/Schema/pain.002.001.03.xsd?r=241

After
begin
   DOK_XML_UTIL.p_vnesi_xsd_blob(401941242); -- store a XSD on file system from blob field 
   
   dbms_xmlschema.registerschema(
    schemaurl => 'http://localhost/TEST1.XSD',
    schemadoc => bfilename('ETAX_LOAD','TEST1.XSD'),
    csid => nls_charset_id('AL32UTF8'));
commit;
end;
I get:

ORA-31084: error while creating table "INIS_PROD"."Document2781_TAB" for element "Document"
ORA-02320: failure in creating storage table for nested table column "XMLDATA"."CstmrPmtStsRpt"."OrgnlPmtInfAndSts"
ORA-01792: maximum number of columns in a table or view is 1000
ORA-02310: exceeded maximum number of allowable columns in table
ORA-06512: at "XDB.DBMS_XMLSCHEMA_INT", line 37
ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 65
ORA-06512: at "XDB.DBMS_XMLSCHEMA", line 136
ORA-06512: at line 4


What I'am doing wrong or what is the reason for this error..
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 17 2013
Added on Dec 20 2012
2 comments
953 views