Re: Writing to a BFILE from OCI

From: Brian Tkatch <brian.tkatch_at_shopsforme.com>
Date: Wed, 07 Aug 2002 09:32:09 -0400
Message-ID: <9682luoge04039ng6833h3k4o6er8guabs@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 - 08:32:09 CDT