Re: Writing to a BFILE from OCI

From: T. Schmidt <t.schmidt_at_rmv.spm.semantica.nl>
Date: Mon, 12 Aug 2002 09:59:46 +0200
Message-ID: <aj7pm7$2pv$1@reader13.wxs.nl>

"Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message news:3d516dd1$0$238$cc9e4d1f_at_news.dial.pipex.com...
> "Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message
> news:7ua49.35175$uj.18831_at_rwcrnsc51.ops.asp.att.net...
> > Go with what works. Thomas is highly knowledgeable and if you are more
> > comfortable in pl/sql then do it in that. Java was the first thing that
> > popped into my head. In this case it may not matter.
> > Jim
> > "Brian Tkatch" <brian.tkatch_at_shopsforme.com> wrote in message
> > news:9682luoge04039ng6833h3k4o6er8guabs_at_4ax.com...
> > > On Wed, 07 Aug 2002 00:11:31 GMT, "Jim Kennedy"
> > > <kennedy-family_at_attbi.com> wrote:
> > >
> > > >You can't write to a BFILE. You could write a java stored procedure
> that
> > > >wrote a lob out to a bfile. So you could put the image in a
temporary
> > lob
> > > >and have the java stored proc write it out to the file system.
> > > >Jim
> > >
> > > Hey, sounds nice. Thank you for responding.
> > >
> > > But do I really need java? I'm sure its nice, but I am more
> > > comfortable with PL/SQL. While searching, I saw that Tom Kyte has an
> > > example in his book of how to write a LOB to file, and WROTZ has the
> > > code online. Would there be any advantages to using Java over PL/SQL
> > > (or vice-versa)?

>
>

> Actually you were strictly correct Jim. You *cannot* write to an OS file
> using pure PL/SQL. Tom's example is an external procedure call to a (pro*)
C
> library. I guess the choice of which you prefer is what language (other
than
> PL/SQL) you are most familiar with.

Actually you *can* write to an OS file using pure PL/SQL.

www.plfile.com :

PL/File is an PL/SQL API (application programming interface). PL/File allows file, directory and ZIP file manipulation on multiple systems at once and enables Oracle developers to integrate these functionalities in their own applications. With PL/File they can create, read and write (ZIP-) files. Check
file type (directory, ZIP file, regular file). Copy and compare (ZIP-) files.
Create, list and remove directories. Manipulate file and directory properties.
Search files with wild cards containing a search string. Secure access to remote
file systems. By using the J2EE architecture and Oracle, PL/File guarantees platform independence.

-TS
http://www.semantica.com Received on Mon Aug 12 2002 - 02:59:46 CDT