ORA-18179: XMLTABLE column expression needs to be specified using XMLTYPE(SEQUENCE) BY REF clause

ORA-18179: XMLTABLE column expression needs to be specified using XMLTYPE(SEQUENCE) BY REF clause


Cause:


Output of the XMLTABLE column expression was passed to an XMLTABLE row expression with PASSING BY REF clause.



Action:


Specify the XMLTABLE column expression using XMLTYPE(SEQUENCE) BY REF clause.