Re: Oracle BLOB transfer utiltiies...

As Dan said, you can use DBMS_LOB. Create a package based around it, it should do *almost* everything you want.

However, to get the BLOB from the DB to a filesystem, you will need to use an external procedure to write the binary info out to file. A CLOB is ok, you can use utl_file.

Metalink has documentation on the external procedure and BLOBs.

HTH M

damorgan <damorgan_at_exesolutions.com> wrote in message news:<3C855F42.4B05A425_at_exesolutions.com>...
> What's wrong with the built-in DBMS_LOB package?
>
> Daniel Morgan
>
>
>
> Pierre Rene de Cotret wrote:
>
> > Is there a DLL out there or an add-on that I can buy out there that will
> > allow me to transfer a BLOB or CLOB (from table row) directly to a Windows
> > filesystem in reasonable time ?
> >
> > The functionality I'm looking for would involve supplying :
> >
> > - Database name / Server / Password ...
> > - Table name
> > - Row ID or Key Value
> > - Field Name
> > - Datatype : // BLOB - CLOB
> > - FileSystem Path
> > - File Name
> > -Operation (Upload / Download)
> >
> > The dream API call would take care of opening the necessary channels and do
> > a High speed transfer to the file system :) ...(I said dream).... A 25MB
> > BLOB takes about 5 minutes with 128MB of RAM. (Solving this problem would
> > ruin my coffee break though).
> >
> > This seems to be a major issue for software developers (Powerbuilder) since
> > the only option available right now is to move the entire data/file (BLOB)
> > from the Oracle server to workstation memory (RAM) and from memory to the
> > file system using 32k chunks (append) !!!!
> >
> > There's gotta be something out there ...
> >
> > Thanks in advance
Received on Wed Mar 06 2002 - 12:44:19 CET