I was trying to get a LONG column into a VARCHAR2(32767) column in PL/SQL block. Then while trying to use functions like SUBSTR, LENGTH on the varchar2 variable, I am getting this error. How to overcome this ?

Ver : 8.0.6