SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Invalid Path error with UTL_FILE

774582Sep 27 2010 — edited Sep 27 2010

Hi Gurus..

I have to load data from .csv file to oracle table.

ON oracle server i have created physical directory D:\TEST and created a TEST1.CSV file

ALso i have created logical directory on oracle sever with CREATE DIRECTORY AS 'D:\TEST' and GRANT READ,WRITE ON TEST TO abc (username)

I have created procedure with below paramerters..
PROCEDURE upload_data_proc (p_directory VARCHAR2, p_filename VARCHAR2)

now when i execute procedure UPLOAD_DATA_PROC('D:\TEST','TEST1.CSV');

It gives me invalid path error..

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 25 2010

Added on Sep 27 2010

2 comments

1,589 views