Is it possible to convert a CLOB datatype to VARCHAR2 in Oracle 8i? I need to do this because I am referencing a field (currently a CLOB) in a crystal report. Crystal cannot read the CLOB in its native format, as far as I am aware it can only read VARCHAR2 fields.
Please can anyone help me?
Thanks
Please can anyone help me?
Thanks