Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Writing to a BFILE from OCI
"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.
-- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ******************************************Received on Wed Aug 07 2002 - 13:58:27 CDT