How to import data into an Oracle from text file.

[saquib1982]

Hi al,

i have to import data in to ORacle from text file using Oracle Forms 9i or above or 6i...

how can i do this? is any body have some idea plz help me its very urgent...

Thanx in advance.

Saquib

[pinkalsolanki]

Its.. simple..

Use TEXT_IO Package in Forms 6i

<b>Sample:</b>
-------------------------------------------
declare
in_file Text_IO.File_Type;
linebuf VARCHAR2(80);
begin
in_file := Text_IO.Fopen('salary.txt', 'r');
Text_IO.Get_Line(in_file,linebuf);

Message(linebuf);

end;
--------------------------------------------
Here its linebuf variable contains your data.