Re: Oracle BLOB transfer utiltiies...

Yeah, what's wrong with it? You can use DBMS_LOB.substr() to retrieve data in chunks and write into file right away, not need to transfer the whole BLOB to the client first.

-- 
Vladimir Zakharychev (bob_at_dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.


"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

>