ORA-18178: XMLType input to XMLTABLE row expression needs to use PASSING BY REF clause

ORA-18178: XMLType input to XMLTABLE row expression needs to use PASSING BY REF clause


Cause:


The XMLTABLE column expression used the XMLTYPE(SEQUENCE) BY REF clause which requires XMLType input to the XMLTABLE row expression to use the PASSING BY REF clause.



Action:


Specify the PASSING BY REF clause for XMLType input to the XMLTABLE row expression.