Oracle PL/SQL Types

There are persistable and non persistable types.

In the data dictionary, persistable and non-persistable types can be identified by the column persistable in dba_types:

select * from dba_types where persistable = 'YES';

I assume that non-persistable types can only be used in PL/SQL, not in SQL, see the error messages

• ORA-22384: cannot create a column or table of a non-persistable type,
• ORA-40573: invalid use of PL/SQL JSON object type and
• ORA-40834: invalid input to JSON parse/load function