ORA-29284: File read error
685925Feb 18 2011 — edited Feb 18 2011Good morning,
Need to do two flat file on a 2000 lien.
1 - Read a file. csv
2 - Keep it plain, unformatted information from a table
These are the steps I performed to achieve the first goal ...
1 - READING TEST FILE
CREATE OR REPLACE DIRECTORY PUBLIC_ACCESS AS 'C:\REPORTES_REY';
GRANT READ, WRITE ON DIRECTORY PUBLIC_ACCESS TO PUBLIC;
-- THIS PL / SQL works ok..
DECLARE
v1 utl_file.file_type;
v2 varchar2(600);
begin
v1:= utl_file.fopen('PUBLIC_ACCESS','prueba20110218.csv','R'); -- WORKS WELL ...
--v1:= utl_file.fopen('PUBLIC_ACCESS','sui_facturacion_alcantarillado_15085_2011_01_76845_001.csv','R');
loop
begin
utl_file.get_line(v1,v2);
dbms_output.put_line('el contenido del archivo es: '||v2);
exception
when no_data_found then
exit;
end;
dbms_output.put_line(' - '); JUMP LINE
end loop;
utl_file.fclose(v1);
exception
when others then
dbms_output.put_line(sqlerrm);
end;
/
but when you change the file name by map prueba20110218.csv de-> sui_facturacion_alcantarillado_15085_2011_01_76845_001.csv displays the following error
ORA-29284: File read error+
- this error to be?
I am grateful for the attention and cooperation extended ...
good day ...
REYNEL SALAZAR MARTÍNEZ
Cali-Colombia