Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Copy files from within Oracle
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.
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
![]() |
![]() |