Re: Blob to Long Raw conversion

From: godmann <allanwtham_at_yahoo.com>
Date: 6 Sep 2001 22:52:02 -0700
Message-ID: <95cd51c.0109062152.9fb9078@posting.google.com>

Hi there,

By the way, long and long raw are for backward compatibility only.

To run the code below, create a table traw with n1 number, l1 long raw and also a table tblob n1 number, l1 blob

See the code below as sample:

declare
amount binary_integer := 32000;
buffer long raw;
cursor c1 is select n1, l1 from tblob order by n1;

begin
for crec in c1 loop
dbms_lob.read(crec.l1,amount,1,buffer); insert into traw values (crec.n1, buffer);

end loop;
end;
/

Allan W. Tham Received on Fri Sep 07 2001 - 00:52:02 CDT