Oracle Server - NT Server
Client Machine - Windows 98
Version - 8.1.5

Work in Server Side
----------------------------
1. I have create directory priviledge.
2. In the Server , in the D: drive I created a folder named tradefiles.
3. I created directory called tradefiles through SYS user.
> CREATE OR REPLACE DIRECTORY TradeFiles AS 'D:\TradeFiles' ;
4. I am able to see the created directory in dba_directories table of SYS.
5. This I did from Server Machine.

Scenario - 1 Work In Client Machine
----------------------------------------------------

1.Create table blob_test (key number(2), file_col bfile)
2.There is file called 'c:\tradetest\trade.doc' in the client machine
3.I issued the following statement in SQL plus
> insert into BLOB_TEST(key, File_col) values ( 1, BFILENAME('TradeFiles',
> 'c:\tradetest\trade.doc');
4.Statement got executed
5.When I tried to open the document from Visual basic application using
OracleInprocServer library, i received a error message
'directory/file does not exist' And this is a oracle error.


Scenario - 2 Work In Client Machine
----------------------------------------------------

1.Create table blob_test (key number(2), file_col bfile)
2.There is file called 'c:\tradetest\trade.doc' in the client machine
3. I phisically copied the above file from client machine to server machine
to the directory 'D:\TradeFiles'
3.I issued the following statement in SQL plus
> insert into BLOB_TEST(key, File_col) values ( 1, BFILENAME('TradeFiles',
> 'c:\tradetest\trade.doc');
4.Statement got executed
5.When I tried to open the document from Visual basic application using
OracleInprocServer library, i received a error message
'directory/file does not exist' And this is a oracle error.

My question is
1. Whether it is necessary to physically copy the file from client machine
to server
2. How to open the specified file stored in column ( using oracle / any
other programming language)
3. How to see whether file got stored in the table ( I mean how to see the
locator)


Arul Prakasam.N
TIDEL Park , Chennai,India
Ph +91-44 - 2549600 - Ext 506,507,508


Arul Prakasam.N
TIDEL Park , Chennai,India
Ph +91-44 - 2549600 - Ext 506,507,508
Oracle LazyDBA home page