Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Writing to a BFILE from OCI
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)?
>
> Brian
Received on Wed Aug 07 2002 - 09:51:47 CDT
![]() |
![]() |