Re: Question about External Tables

From: Jack Schmidt <thejackschmidt_at_gmail.com>
Date: Sun, 14 Aug 2011 23:15:26 -0700 (PDT)
Message-ID: <b6bfe3d2-f29f-4fd5-b094-2b3d3002b159_at_glegroupsg2000goo.googlegroups.com>



UPDATE:
I wrote a test pl/sql package using the file_utl to read and print a line.

In my database server, I am able to execute it and it prints out the information fine. If I connect via Oracle client and execute the pl/sql, I get an error.

ERROR at line 1:

ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 488
ORA-29283: invalid file operation
ORA-06512: at "TEST.DBG_EXT_UTIL", line 8
ORA-06512: at line 1

Here is my debug pl/sql package.

create or replace package dbg_ext_util as   procedure dbg_test_read;
end;
/

show errors;

create or replace package body dbg_ext_util as

    procedure dbg_test_read
    is

        v1 varchar2(32767);
        f1 utl_file.file_type;
    begin
        f1 := utl_file.fopen('EXT_TEST','temp.csv','R');
        utl_file.get_line(f1,v1);
        utl_file.fclose(f1);
        dbms_output.put_line(v1);

    end;
end;
/

show errors; Received on Mon Aug 15 2011 - 01:15:26 CDT

Original text of this message