BLOBs via JDBC

From: Ken Harvey <Ken.Harvey_at_iconmedialab.co.uk>
Date: Fri, 26 Jan 2001 16:56:31 -0000
Message-ID: <94s9ru$g00$1@reader-00.news.insnet.cw.net>

Hello All,

I am using Oracle 8i 8.1.6 on Win NT 4.0. My colleague is using Tom Cat to build web pages and is accessing the database via JDBC.

We are trying to store a Word document in a BLOB field. So far my colleague's code copies the document from the client to a temporary directory on the Oracle server's file system. It then calls a stores procedure using JDBC that created a row and reads they temporary file into the BLOB field. Finally the code deletes the temp file on the server.

I was wondering if it was possible to get Oracle to read the file directly from the client, thereby removing the need to create the temporary file.

Thanks for any help.

Ken. Received on Fri Jan 26 2001 - 10:56:31 CST