Re: writing the content of a BLOB to a file (unix)
From: Yong Huang <yhuang_at_indigopool.com>
Date: Tue, 5 Sep 2000 13:02:10 -0500
Message-ID: <8p3ckb$6v1$1_at_news.sinet.slb.com>
> > I'm on Unix Solaris. Oracle 8.1.6.
> >
> > I have a table with a primary key column and a BLOB column.
> >
> > For each row of the table, I want to create a binary file on my OS
with:
> > -name = primary key
> > -content = content of the BLOB column
> >
> > (How) can I do this ?
> > I know there is a UTL FILE package but it only seems to work with text
> > files...
Received on Tue Sep 05 2000 - 20:02:10 CEST
Date: Tue, 5 Sep 2000 13:02:10 -0500
Message-ID: <8p3ckb$6v1$1_at_news.sinet.slb.com>
Mr. Kyte answered a question for me at
http://osi.oracle.com/wa/ask/owa/ask_tom_pkg.display?p_dispid=624423639385&p _search_str=%7BYONG%7D%20and%20%7BHUANG%7D
You can pursue by asking more about writing an external procedure.
Yong Huang
> "Jean-Michel Scheiwiler" <scjm_at_cybercable.fr> wrote:
> > I'm on Unix Solaris. Oracle 8.1.6.
> >
> > I have a table with a primary key column and a BLOB column.
> >
> > For each row of the table, I want to create a binary file on my OS
with:
> > -name = primary key
> > -content = content of the BLOB column
> >
> > (How) can I do this ?
> > I know there is a UTL FILE package but it only seems to work with text
> > files...
Received on Tue Sep 05 2000 - 20:02:10 CEST