Oracle Error ORA-19207: scalar parameter string of XMLELEMENT cannot have an alias.

Oracle Error Message

ORA-19207: scalar parameter string of XMLELEMENT cannot have an alias.

Reason for the Error

The scalar parameter to XMLELEMENT has been qualified with an alias.

Solution

Remove the AS clause of the scalar element.

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

Oracle Error Message ORA-24328: illegal attribute value Reason for the Error The attribute value passed in is illegal. Solution Consult...
Oracle Error Message ORA-01346: LogMiner processed redo beyond specified reset log scn Reason for the Error LogMiner has detected a...
Oracle Error Message ORA-13241: specified dimensionality does not match that of the data Reason for the Error An error occurred...