This discussion is archived
1 Reply Latest reply: Nov 5, 2012 8:54 AM by Steve_Clamage RSS

How to use c# to save Bfile from local PC to server folder

498256 Newbie
Currently Being Moderated
i have the table
CREATE TABLE HRADMIN.ARCHIVING_DATA
(
TEMP_ID NUMBER(3),
FOLDER_CODE NUMBER(4),
FILE_TITLE VARCHAR2(40 BYTE),
CREATION_DATE DATE DEFAULT sysdate,
OCR_DATA VARCHAR2(4000 BYTE),
A_DOCUMENT     BFILE,
REG_USER VARCHAR2(35 BYTE) DEFAULT user,
REG_DATE DATE DEFAULT sysdate,
FILE_KEY VARCHAR2(30 BYTE),
TAG1 VARCHAR2(150 BYTE),
TAG2 VARCHAR2(150 BYTE)
)
I'm trying to save picture file from local PC to my table using C# and OracleDataprovider.
but i can't save a picture from my local PC to server because it must be first loaded to oracle server directory
Is there any procedure to save picture direct from my local PC to oracle bfile without loading the picture first to oracle directory.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points