ORA-19029: Cannot convert the given XMLType to the required type

ORA-19029: Cannot convert the given XMLType to the required type

Cause: The passed in XMLType could not be convert to the required type

Action: Binary XMLtype instances or other objects cannot be converted to the required object or collection types.

ORA-19028: Invalid ADT parameter passed to toObject() function

ORA-19028: Invalid ADT parameter passed to toObject() function

Cause: The object passed as ADT parameter to sys.XMLType.toObject() is not the same type, or a super-type, of the mapped type.

Action: Pass an object of the correct type to toObject().

ORA-19026: EXTRACTVALUE can only retrieve value of leaf node

ORA-19026: EXTRACTVALUE can only retrieve value of leaf node

Cause: Given XPath does not point to a leaf node.

Action: Rewrite the query so that a leaf node is returned.

ORA-19025: EXTRACTVALUE returns value of only one node

ORA-19025: EXTRACTVALUE returns value of only one node

Cause: Given XPath points to more than one node.

Action: Rewrite the query so that exactly one node is returned.

ORA-19024: Cursor expression must be named

ORA-19024: Cursor expression must be named

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-19023: The first argument to UPDATEXML operator has to be an XMLTYPE

ORA-19023: The first argument to UPDATEXML operator has to be an XMLTYPE

Cause: The first argument passed to the update value operator was not an XMLTYPE.

Action: Rewrite the query so that the first argument to the UPDATEXML operator is XMLTYPE.

ORA-19020: invalid dereference of XMLType columns

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