How to fix the Oracle error ORA-64139: The type of VIRTUAL column is not XMLTYPE?

In this post, you’ll learn more about the Oracle ErrorORA-64139: The type of VIRTUAL column is not XMLTYPE with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-64139: The type of VIRTUAL column is not XMLTYPE

Reason for the Error ORA-64139: The type of VIRTUAL column is not XMLTYPE

An attempt was made to create an XML index with VIRTUAL column not of XMLTYPE.

How to fix the Error ORA-64139: The type of VIRTUAL column is not XMLTYPE ?

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

Specify the type of VIRTUAL column to be XMLTYPE.