Can't update 4K long datatype in PL/SQL

From: <leirace_at_my-dejanews.com>
Date: Fri, 21 May 1999 03:17:36 GMT
Message-ID: <7i2j8e$1gq$1@nnrp1.deja.com>

I want update a long datatype in my table . my procedure:

        v_detail varchar2(10000);
        l_detail long;
        cursor c_mbox is select rowid, name, detail from mbox;

BEGIN
    for c1 in c_mbox loop

	v_detail :=c1.detail;
	l_detail:=replace(v_detail,'(',chr(13)||chr(10));
	update mbox set detail=l_detail where rowid=c1.rowid;

    end loop;
end

   when the detail < 4K the update can work. if the detail > 4K , It's tell me
ORA-01461 can bind a LONG value only for insert into a LONG column

  Thanks for you help

                                       Leirace

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Thu May 20 1999 - 22:17:36 CDT