Skip to Main Content

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!

ORA-29284: File read error

685925Feb 18 2011 — edited Feb 18 2011
Good 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
This post has been answered by Solomon Yakobson on Feb 18 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 18 2011
Added on Feb 18 2011
3 comments
2,264 views