Oracle Database Errors or Warnings from Error ORA-31155 to ORA-31165

SQLServerF1

ORA-31155: attribute string not in XDB namespace
Cause: The specified attribute should be prefixed with XDB’s namespace.
Action: Ensure that all XDB specified attributes are prefixed with XDB’s namespace and try again.
ORA-31157: Invalid Content-Type charset
Cause: HTTP Content-Type header had a charset that Oracle does not understand.
Action: Fix the Content-Type header in the HTTP request.
ORA-31158: schema “string” currently being referenced
Cause: The specified schema URL is currently being referenced by the same session. This could happen because of PLSQL XMLType variables still in scope.
Action: Ensure all references to this schema in this session are released and try the operation again.

ORA-31159: XML DB is in an invalid state
Cause: XML DB’s internal tables are in an invalid state, probably because the database was not upgraded or the upgrade was not successful
Action: Ensure that the database is upgraded successfully. If the problem persists, contact Oracle Support
ORA-31160: max substitution group size string exceeded by “string” (string) for head element “string” (string)
Cause: The maximum limit on nested substitution groups has been exceeded by an element.
Action: Delete specified schema and re-register it after removing the offending substitution element.
ORA-31161: element or attribute “string” cannot be stored out of line
Cause: An element or attribute of a simple type has SQLInline=false
Action: Remove the SQLInline=false qualification for the offending element or attribute

ORA-31162: element or attribute “string” has no SQLType specified
Cause: Schema registration was invoked with GENTYPES=false without specifying a SQLType for some element or attribute
Action: Specify a SQLType for the offending element or attribute and register the schema again
ORA-31163: element or attribute “string” has invalid attribute value “string” (should be “string”)
Cause: An element or attribute for a complextype derived by restriction has an attribute whose value is different from that in the base type
Action: Remove the mismatched attribute values from the offending element or attribute
ORA-31164: cannot load object-relational XML attribute using direct path
Cause: The table being loaded contains a xml column with object-relational storage. The xmltype column contains a type with subtypes. This type of attribute cannot be loaded with direct path.
Action: Perform the load with conventional path mode.
ORA-31165: cannot load object-relational XML attribute using direct path
Cause: The table being loaded contains a xml column with object-relational storage. The xmltype column either contains an out-of-line partitioned table or the table itself is partitioned by one of the attributes of xmltype. This type of table cannot be loaded with direct path.
Action: Perform the load with conventional path mode.

Above are list of Oracle Database Errors or Warnings from Error ORA-31155 to ORA-31165 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *