Category Archives: ORA Database Error Messages

ORA-31167: XML nodes over 64K in size cannot be inserted

oracle

ORA-31167: XML nodes over 64K in size cannot be inserted
Cause: An attempt was made to insert an XML Text Node with a size greater than 64K. This is not supported
Action: Create text nodes under 64K

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31165: cannot load object-relational XML attribute using direct path

oracle

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

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31164: cannot load object-relational XML attribute using direct path

oracle

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

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31163: element or attribute “string” has invalid attribute value “string” (should be “string”)

oracle

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

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31162: element or attribute “string” has no SQLType specified

oracle

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

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31161: element or attribute “string” cannot be stored out of line

oracle

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

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31160: max substitution group size string exceeded by “string” (string) for head element “string” (string)

oracle

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

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31159: XML DB is in an invalid state

oracle

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

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31158: schema “string” currently being referenced

oracle

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

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-31157: Invalid Content-Type charset

oracle

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

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/