How to fix the Oracle error ORA-64140: missing chaining XMLTABLE for VIRTUAL column in the index?

In this post, you’ll learn more about the Oracle ErrorORA-64140: missing chaining XMLTABLE for VIRTUAL column in the index with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-64140: missing chaining XMLTABLE for VIRTUAL column in the index

Reason for the Error ORA-64140: missing chaining XMLTABLE for VIRTUAL column in the index

An attempt was made to create an XML index with VIRTUAL column but without required chaining XMLTABLE.

How to fix the Error ORA-64140: missing chaining XMLTABLE for VIRTUAL column in the index ?

You can fix this error in Oracle by following the below steps

Specify a chaining XMLTABLE after VIRTUAL column.