Converitng LONG to CHAR

Hi,

I eould like to convert a LONG to a char field. In the newsgroup I found the following sp:

CREATE OR REPLACE Function Long2Char(lngVal IN long) RETURN VARCHAR2 IS lngResult
VARCHAR2(2000);
Begin
  lngResult := lngVal;
  Return (lngResult);
End;
/

This compiles without any problem but if I try to access it:

SQL> select long2char(long_field) from my_table;

I get: ORA-00997: illegal use of LONG datatype

What can I do? Received on Sat Mar 04 2000 - 00:00:00 CST