Skip to Main Content

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!

ORA-31085 schema "" already registered

945967Jun 26 2012 — edited Jun 28 2012
To all,

We are getting an ORA-31085 schema "" already registered on 11g. There are no registered schema in: SQL> SELECT * FROM USER_XML_SCHEMAS;

no rows selected.

This error is preventing a stored procedure from executing and properly completing a critical INSERT statement.

Does anyone have any idea why we'd encounter this when attempting to INSERT into a table with a single column of XMLTYPE.

We receive the XML via a CLOB datatype INPUT variable in the stored procedure and then cast it as XMLTYPE(column_xml_data).

Thanks,
Eric
This post has been answered by Marco Gralike on Jun 27 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 26 2012
Added on Jun 26 2012
15 comments
4,834 views