how i can read text file located on a different server then that of my database
Posted on 2008-11-05
i need to access and read some text file located on a server different from that where my database is located. i need to read the data from these files to load them in table in my database. for some reason i cannot setup the procedure that i have built to read the files from the other server. but when i use a test path located on the database machine, i can read a test file.
in the proceudre i am using ths syntax
-- grant permission to frost_addons
dbms_java.grant_permission('FROST_ADDONS','SYS:java.net.SocketPermission','ip address:port no ','connect, listen,accept,resolve');
-- get file quantity
select recon_GetFileqty(v_path2) into v_file_qty from dual;