ORA-31085 schema "" already registered
945967Jun 26 2012 — edited Jun 28 2012To 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