Re: Extracting Files Stored as BLOBs
From: SoulSurvivor <markyg_7_at_yahoo.co.uk>
Date: 2 May 2003 00:49:29 -0700
Message-ID: <8d9c6fd.0305012349.4cb4b92c_at_posting.google.com>
Date: 2 May 2003 00:49:29 -0700
Message-ID: <8d9c6fd.0305012349.4cb4b92c_at_posting.google.com>
- You have to convert the data to rawtohex format. Directly sending the buffer
- data will not work
- That is the reason why we are sending the length as the double the
size of the data read
dbms_output.put_line('Read ' || to_char(len) || 'Bytes');
else
- If the col length is > 10000
DBMS_LOB.READ(i1,i3,i2,my_vr);
outputstring('p:\bfiles\ravi.bmp',rawtohex(my_vr),'wb',2*i3);
dbms_output.put_line('Read ' || to_char(i3) || ' Bytes ');
end if;
i2 := i2 + 10000;
while (i2 < len ) loop
- loop till entire data is fetched
DBMS_LOB.READ(i1,i3,i2,my_vr);
dbms_output.put_line('Read ' || to_char(i3+i2-1) || ' Bytes ');
outputstring('p:\bfiles\ravi.bmp',rawtohex(my_vr),'ab',2*i3);
i2 := i2 + 10000 ;
end loop;
end;
- loop till entire data is fetched
DBMS_LOB.READ(i1,i3,i2,my_vr);
dbms_output.put_line('Read ' || to_char(i3+i2-1) || ' Bytes ');
outputstring('p:\bfiles\ravi.bmp',rawtohex(my_vr),'ab',2*i3);
i2 := i2 + 10000 ;
end loop;
end;
- If the col length is > 10000
DBMS_LOB.READ(i1,i3,i2,my_vr);
outputstring('p:\bfiles\ravi.bmp',rawtohex(my_vr),'wb',2*i3);
dbms_output.put_line('Read ' || to_char(i3) || ' Bytes ');
end if;
i2 := i2 + 10000;
while (i2 < len ) loop
"Gnarly" <nick.marks_at_uk.thalesNOSPAMgroup.com> wrote in message news:<b8rbqv$qrv$1_at_rdel.co.uk>...
> I am working on migrating data from a legacy application that stores files
> as BLOBs in an oracle table, I need to get these files out to the OS for
> input to the new system.
>
> Is there a Tool for extracting these files out to OS level files?
Received on Fri May 02 2003 - 09:49:29 CEST