|
|
Re: How to read contents of a file as a string in Forms [message #87501 is a reply to message #87487] |
Sat, 08 January 2005 01:21  |
ashish
Messages: 107 Registered: December 2000
|
Senior Member |
|
|
hi
u can use text_io pkg for this..
here the e.g
declare
in_file Text_IO.File_Type; ----file tyoe
linebuf VARCHAR2(80); -----to stroe text read from file
begin
in_file := Text_IO.Fopen('c:file.txt', 'r'); ------ open file
loop ---------- start reading file
text_IO.Get_Line(in_file,linebuf); -----get line from file
/*my screenn field (multipal record field) */:text := linebuf; ------put that line in text
next_record; -----move to next record in data block
end loop; ------end of file
exception
when others then
message('sqlerrm '||sqlerrm);
end;
******************
regards
ashish
|
|
|