Getting ORA-29283 error when opening CSV file using UTL_FILE.FOPEN

360 pts.
Tags:
Oracle 10g
SQL
SQL scripts
I have a SQL script and all it does in to open a CSV file using UTL_FILE.FOPEN. I keep getting the ORA-29283 error.  I have an Oracle directory object pointing to the file location. Here is the code snippet: create or replace procedure "SKINNY" as
v_inputfile             utl_file.file_type;
v_filedata              varchar2(4000) := null;
v_filename              varchar2(50) := null;

-----------------------------------------------------------------------
--  CODE EXECUTION
-----------------------------------------------------------------------
BEGIN

v_filename := 'inputfile.csv';
v_inputfile := utl_file.fopen('LAB_INTERFACES',v_filename,'A',32767);  
END;

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • carlosdl
    Most of the times that error is raised because of access permissions at the OS level.
    79,775 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: