Re: java stored procedure code example

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Fri, 04 Oct 2002 19:25:44 +0200
Message-ID: <knjrpuk2poh7vtva1us6aboaseikg6nke8@4ax.com>

On Fri, 4 Oct 2002 15:10:05 +0100, "Jeremy Ovenden" <newsposter_at_hazelweb.co.uk> wrote:

>Looking for help with the following. I have a table with a BLOB
>column containing binary data (e.g. MS Word docs, jpeg images
>etc.)
>
>I want to write these files out to a BFILE on the o/s.
>
>I believe the only method for doing this is to either write an
>external proc or to write a jsp to do it. Not knowing java is a
>handicap! So am looking to see if anyone has done something
>similar and could at least share an outline?
>
>BTW this an Oracle 8.1.7+ database.
>
>TIA
Just study the procedures in the DBMS_LOB package in your documentation.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Oct 04 2002 - 12:25:44 CDT