SQL & PL/SQL

Hi All,

Please help..

Running into an issue with the 11g upgrade. Our platform generates on occasion long character data over 4 kb in length (Long datatype). Prior to the 11g upgrade, the backward compatibility support for Long data types existed, and the program functioned without error as it was able to update >4k of data into a long column.

But after upgrading to Oracle 11gR2 we are getting an ORA error (ORA-01461 - can bind a LONG value only for insert into a LONG column).

The PL/SQL is as below..

DECLARE
myclob LONG ;
BEGIN
myclob:='select -----'
ELSE
dbms_output.put_line('1111111');
update RpsQuery set Query=myclob where ---;
END IF;
END;

Thanks & Regards,

Deepak