Oracle Database Errors or Warnings from Error ORA-19034 to ORA-19043

SQLServerF1

ORA-19034: Type not supported during schema generation
Cause: The object type contained a type that is not supported for schema generation.
Action: Use a different type or do not generate a schema.
ORA-19035: Invalid select item of the query in newContextFromHierarchy()
Cause: The query does not have a number select item followed by an XMLType select item only.
Action: Make sure the result set of the query used in the newContextFromHierarchy() must have only two selected items: the first item must be number type and the second item must be XMLType.
ORA-19036: Invalid query result set in newContextFromHierarchy()
Cause: The result set of the query used in the newContextFromHierarchy() does not have the same property as the result set generated by a CONNECT BY query.
Action: Make sure the query used in newContextFromHierarchy() is a CONNECT BY query or the query returns the result set have the same property as the result set generated by a CONNECT BY query.

ORA-19037: XMLType result can not be a fragment
Cause: The select item of the query in newContextFromHierarchy() is an XML fragment.
Action: Make sure the select item of the query in newContextFromHierarchy() is NOT an XML fragment
ORA-19038: Invalid opertions on query context
Cause: SetMaxRows, SetSkipRows, SetRowTagName opertions are applied to a query context created from newContextFromHierarchy().
Action: SetMaxRows, SetSkipRows, SetRowTagName opertions can not be applied to a query context created from newContextFromHierarchy().
ORA-19039: Keyword string reserved for future use
Cause: The keyword is reserved for future use as a builtin function.
Action: Change the name mentioned above to a different one.

ORA-19040: Element string does not match expected string.
Cause: The given XML document had a different root element than expected.
Action: Insert/Update only the XML documents that conform to that particular schema and element.
ORA-19041: Comment data cannot contain two consecutive ‘-‘s
Cause: The given comment string expression has two consecutive ‘-‘s.
Action: Modify comment string to eliminate one or both of the consevutive ‘-‘s.
ORA-19042: Enclosing tag string cannot be xml in any case combination
Cause: The given enclosing tag matched ‘xml’ in some case combination
Action: Modify the enclosing tag so that it is not xml in any case combination.
ORA-19043: Multiply nested XMLROOT function disallowed
Cause: An XMLROOT function has an operand that is also an XMLROOT function.
Action: Modify the query so that there are no multiply nested XMLROOT functions.

Above are list of Oracle Database Errors or Warnings from Error ORA-19034 to ORA-19043 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 *