Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Copy files from within Oracle

Copy files from within Oracle

From: <Sherrie.Kubis_at_swfwmd.state.fl.us>
Date: Fri, 30 Mar 2001 12:35:15 -0800
Message-ID: <F001.002DD664.20010330111550@fatcity.com>

Oracle RDBMS 8.1.5.0.0.
Digital UNIX 4.0f

This seems like it should be such a simple thing to do. One of my developers is
writing a VB application for a user to (1) scan an image using a scanner connected to
their PC. Then, (2) take that file and store it on our UNIX Oracle server in a BFILE
directory. Next, (3) the file is inserted into an Oracle table as a BFILE column.

The issue that I have is with step 2. We can copy from the desktop to the UNIX
server using VB, but the directory location on the UNIX side must have permissions to
allow the user write access. If this is indeed a secure Oracle BFILE area, then
the operating system account 'oracle' should be the only guy allowed to write here.

Under MetaLink I found a suggestion to use DBMS_PIPE and an external C procedure,
but this requires Pro*C, which we don't have.

We are just learning about BFILEs, and are forced to use VB because of our third-party
software. How would you go about doing this?

Any insights would be appreciated.



Sherrie Kubis
Southwest Florida Water Management District 2379 Broad Street
Brooksville FL 34604-6899

Mailto:Sherrie.Kubis_at_swfwmd.state.fl.us

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: Sherrie.Kubis_at_swfwmd.state.fl.us

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Mar 30 2001 - 14:35:15 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US