DBMS_LOB and Virtual Directories

Hi,

I have created an app using DBMS_LOB. To read and transfer BFILES, you have to create a directory in Oracle using...

    Create Directory VIRTUAL_DIR for "c:\temp";

You then use this VIRTUAL_DIR to access the files in c:\temp. This works fine in 2-tier mode but when i try in 3-tier mode over the web, it complains about not finding the file i referenced.

I then assumed that the mapping has to be in relation to the middle tier (server) directory structure. Changed it, still didn't work. I then changed it to match the client structure, still failed.

Question is does the virtual directory mapping work in 3-tier mode? Any replies by email as well please.

HELP! ;-( Mark

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!