Re: reading bfiles
From: Maurício Bellissimo Falleiros <mbf_at_uniconsult.com.br>
Date: Mon, 27 Sep 1999 18:10:18 -0300
Message-ID: <37EFDD3A.FC750973_at_uniconsult.com.br>
exception
when no_data_found then exit; -- EOF gives you a no_data_found end;
end loop;
TEXT_IO.fclose(handle);
Date: Mon, 27 Sep 1999 18:10:18 -0300
Message-ID: <37EFDD3A.FC750973_at_uniconsult.com.br>
Hi Burke,
you should try the TEXT_IO package. I works in a C-fashion:
handle := TEXT_IO.fopen("Your_File_Name", "r"); -- "r" for "read", "w"
for write
loop
begin
TEXT_IO.get_line(handle, varchar2_local_variable);
...
-- work on the line you got
...
exception
when no_data_found then exit; -- EOF gives you a no_data_found end;
end loop;
TEXT_IO.fclose(handle);
On-line Developer's Help gives you more...
Good luck,
Maurício
-- Maurício Bellissimo Falleiros <mailto:mbf_at_uniconsult.com.br> Uniconsult Sistemas e Serviços <mailto:uss_at_uniconsult.com.br> R. Demóstenes, 627 cj.134/142 - Campo Belo - São Paulo/SP - 04614-013 Brasil Fone/Fax: +55-11-5350885 +55-11-5333335 "Em um minuto apenas há tempo Para decisões e revisões que um minuto revoga." T.S.Eliot * Sent from RemarQ http://www.remarq.com * The Internet's Discussion Network * * The fastest and easiest way to search and participate in Usenet - Free! *Received on Mon Sep 27 1999 - 23:10:18 CEST