Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help Me !!! BLOB
This is *not* possible with pl/sql (dbms_lob and utl_file can't do that job since utl_file only writes varchar2).
It can be done using an external procedure written in C that is invoked from pl/sql. A ready-to-run example is given in Oracle Metalink (Doc ID: 70110.1)
Klaus
Alberto <rho65_at_hotmail.com> schrieb in im Newsbeitrag:
gc339t06iruh83e8ue0c3tbv675i99eusd_at_4ax.com...
> I have the following kind of table:
>
> Create table ENCLOSED_PHYSICAL(
> tipo varchar2 (20),
> ......
> allegato BLOB
> .........
>
>
> ".pdf" files have been saved into the enclosed "BLOB" field.
> Is it possible, using a direct command working with a procedure
> PL/SQL, to extract the files and to save them into my PC Hard Disk ?
>
> Thanks in advance
> Alberto
>
> rho655_at_hotmail.com
>
Received on Wed Feb 21 2001 - 03:24:28 CST