Oracle Database Errors or Warnings from Error ORA-31167 to ORA-31186

SQLServerF1

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.
ORA-31168: Node localname and namespace values should be less than 64K
Cause: An attempt was made to specify an XML Node with localname or namespace value greater than or equal to 64K. This is not supported.
Action: Node localnames and namespace values should be under 64K.
ORA-31169: Number of children (string) defined in ‘string’ exceeds maximum (string)
Cause: An attempt was made to define more than the allowed number of children in a complexType of an XMLSchema document.
Action: Modify the XML Schema to move children of complexType into subelements that are not inlined.

ORA-31176: API not supported in this release
Cause: This API was not supported.
Action: None
ORA-31180: DOM Type mismatch in invalid PL/SQL DOM handle
Cause: The specified PL/SQL DOM handle is referencing a DOM Node whose DOM Type that does not match the one available in the session. This could happen because the pl/sql handle was reused, or the original document is no longer available.
Action: Ensure that the pl/sql handle for the target node is valid and try the operation again.
ORA-31181: PL/SQL DOM handle accesses node that is no longer available
Cause: The specified pl/sql handle is referencing a node in a DOM Document that is no longer available.
Action: Ensure that the pl/sql handle for the target node is valid and try the operation again.

ORA-31182: Too many PL/SQL DOM handles specified
Cause: An attempt was made to create a PL/SQL DOM handle that exceeded the maximum allowable number of PL/SQL DOM handles.
Action: Free PL/SQL DOM handles and try the operation again.
ORA-31183: Node type string cannot be converted to desired type
Cause: The given node’s type cannot be converted correctly for this operation. For example, a DOM Element cannot be converted to Document Fragment
Action: Pass a valid node type for the conversion.
ORA-31185: DOM Nodes do not belong to the same DOM Document
Cause: The specified PL/SQL DOM Node does not belong to the parent DOM Document of the referring DOM Node.
Action: Ensure that both the DOM Nodes are part of the same DOM Document.
ORA-31186: Document contains too many nodes
Cause: Unable to load the document because it has exceeded the maximum allocated number of DOM nodes.
Action: Reduces the size of the document.

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

What are atOracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Dabase 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 *