Beginning with Oracle Database 12c, you can use ALTER TABLE to store ADTs with XMLTYPEs and LOB attributes in ANYDATA columns. You can also do the same for standalone XMLTYPEs.

• Use the modify_opaque_type clause, which instructs the database to store these types unpacked. Otherwise, they cannot be stored in an ANYDATA column.