Search notes:

ORA-24856: invalid use of TO_LOB operator

With improved error messages, the following statement throws ORA-24856: invalid use of TO_LOB operator:

select
   to_lob('xyz')
from
   dual;

Without improved error messages, the statement throws ORA-00932: inconsistent datatypes: expected - got CHAR

See also