Hi,
I have a form (forms 11g) that asks the user for a file (the file is on the users PC), then I call a PROC that tries to OPEN the file using UTL_FILE.FOPEN...
When the user clicks on 'Load File', I parse the file name and pass the Directory (from users PC) and filename is separate variables
Once in the PROC, I execute the UTL_FILE.fopen using the p_dir and p_filename passed from the form.
But I get an error because the file was not found (the file exists on the users PC).
Can I use the remote directory (users PC) instead of the ORACLE DIRECTORY in my PROC to open the users file???
Oracle thinks that p_dir is an ORACLE DIRECTORY,... But it's not, it's the windows PATH for the file...
Please Help,
Marc L