You Asked
Hi Sir,
I'm using the Oracle 9i database in the HP-UNIX system.
The directory name is "XX_DATA"
Shared network path "\\mkees01\public\Details.csv"
May you please help me by providing the code for below scenario.
From the Shared network path file - Details.csv how to copy to the oracle database directory?
Regards,
Sankar
and Connor said...
Sorry - isn't this just
UTL_FILE.FCOPY(src_location => 'MY_DIR',
src_filename => 'Details.csv',
dest_location => 'MY_OTHER_DIR',
dest_filename => 'Details.csv');
and you need to ensure the oracle account has access to the share/mapped drive ec
Is this answer out of date? If it is, please let us know via a Comment