Oracle Database Errors or Warnings from Error ORA-19011 to ORA-19020


ORA-19011: Character string buffer too small
Cause: The string result asked for is too big to return back
Action: Get the result as a lob instead
ORA-19012: Cannot convert XML fragment to the required datatype
Cause: A conversion to a datatype was requested which cannot be performed
Action: The XMLType may contain fragments and other elements which cannot be converted to the appropriate datatype.
ORA-19013: Cannot create VARRAY columns containing XMLType
Cause: An attempt was made to create a VARRAY column which contains a XMLType
Action: You cannot store VARRAYs containing XMLTypes in tables. Use nested tables instead

ORA-19015: Invalid XML tag identifier (string)
Cause: An invalid XML identifer was detected during XML generation
Action: Fix the offending tag to not contain characters or symbols that are not allowed by the XML specification
ORA-19016: attributes cannot occur after element specifications
Cause: Attributes specified using the “@” identifier can only occur before any other element definition when creating XML
Action: Change the order of the types so that the attributes occur in the begining
ORA-19017: Attributes can only be simple scalars
Cause: Attribute values can only be simple scalar values
Action: Use only simple datatypes for attribute values

ORA-19018: Invalid character in XML tag ‘string’
Cause: A tag name was found to have an invalid XML character during XML generation.
Action: Rewrite the query so that the generated XML tag, corresponding to a column name or alias, contains only valid characters.
ORA-19019: Invalid context passed to DBMS_XMLGEN.GETXML
Cause: The value of context passed to GETXML was invalid.
Action: Rewrite the query so that the value of context passed to GETXML is valid.
ORA-19020: invalid dereference of XMLType columns
Cause: An attempt was made to dereference the attributes of an XMLType column which is not part of a base table
Action: You can only dereference the attributes of a base table XMLType column

Above are list of Oracle Database Errors or Warnings from Error ORA-19011 to ORA-19020 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.

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 *