I think this will work only if the values in the LONG RAW column are
less than 32K (the maximum size of a varchar2 PL/SQL variable.) Your
note about 2000 being the limit might be related to the maximum size of
a varchar2 table column in Oracle 7?=20
-----Original Message-----
Barbara Baker
Matt:
doesn't need to be pro*c -- you can do it with pl/sql.
I believe this will work:
-------------------------------------------------------
create or replace procedure LOAD_T_SCN is
cursor c0 is
select rowid,
SCN_DATA
from SCN;
begin
for c1 in c0 loop
update T_SCN
set T_SCN_DATA =3Dc1.SCN_DATA
where rowid =3D c1.rowid;
end loop;
end;
I have a note to myself that the long needs to be <=3D
2000 characters, so I hope yours is. Can't remember
why I have this note . . .
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------