This article would demonstrate how to export table data into
CSV file using Oracle Forms Developer.
To fulfil this task, you need Oracle Database, Oracle Forms
Developer with client libraries installed e.g client_Text_IO. Follow the
following steps to run the code given below:
1. Create “Location” table in your Oracle database
Create
table Location(
Location_code varchar(20),
state varchar(20),
Location_details varchar(100)
);
2. Insert some rows into the table
Insert into Location(‘LHE,’PUJ’,’LAHORE’);
Insert into Location(‘KHI’,’SIN’,’KARACHI’);
3. Paste the following code on button pressed trigger in
your form. Then compile and run your form.
DECLARE
— File handler
lv_File client_Text_IO.File_Type;
–File
Name
lv_File_Name VarChar2(30);
—
Timer variable
lv_wait timer;
Cursor Load_Rows is
select
v.Location_code||’,’||
v.state||’,’||
v.Location_details data
from Location v;
BEGIN
— File Path
lv_File_Name := ‘C:\temp\Locations.csv’;
–Open file in write mode
lv_File :=
client_text_io.FOpen(lv_File_Name,’W’);
— Write header columns
client_text_io.Put_Line(lv_File,’Code,State,Location
Name/Details,Locality,Post Code,Output Type,Active?’);
–Write rows into the file
FOR i IN Load_Rows LOOP
client_text_io.Put_Line(lv_File, i.DATA);
END LOOP;
–Close File
client_text_io.FClose(v_File);
–Open file in read mode
lv_File :=
client_text_io.FOpen(lv_File_Name,’R’);
–Close file
client_text_io.FClose(lv_File);
lv_wait := create_timer(‘gen_doc’, 2500,
NO_REPEAT);
END;
