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.
end;
end;
/
show errors; Received on Mon Aug 15 2011 - 01:15:26 CDT
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