Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How to manage two OS Text files in UTL_FILE Package simultaneously?
Hi
I am using UTL_FILE Package in order to insert rows into my table from
the OS text files.
It inserts the row in one of the column in the table successfully.
But when I change the code in following routine in order to insert two
rows from the two OS text files, it fails and no row inserted in any
column of the table.
Could someone assist what changes I will do in the following script in
order to insert the rows in both the columns of the table from the two
different OS Text files simultaneously?
The UTL_FILE_DIR parameter is set to * . I am using Oracle 8.1.7.
Following is the procedure, which I am trying to insert the rows in two columns at a time:
Thanks
Sharbat
Declare
l_file_handle1 UTL_FILE.FILE_TYPE;
l_file_handle2 UTL_FILE.FILE_TYPE;
l_buffer1 VARCHAR2(4000);
l_buffer2 VARCHAR2(4000);
BEGIN
l_file_handle1 := UTL_FILE.FOPEN('c:\Test\Result', 'System_Name.txt',
'r', 4000);
l_file_handle2 := UTL_FILE.FOPEN('c:\Test\Result',
'Machine.txt', 'r', 4000);
loop
UTL_FILE.get_line(l_file_handle1,l_buffer1); UTL_FILE.get_line(l_file_handle2,l_buffer2);
insert into test (Hostname,Machine) values(l_buffer1,l_buffer2);
commit;
end loop;
exception
when no_data_found then
UTL_FILE.FCLOSE(l_file_handle1);
UTL_FILE.FCLOSE(l_file_handle2);
when others then
if utl_file.is_open(l_file_handle1)
then
utl_file.fclose(l_file_handle1);
end if;
if utl_file.is_open(l_file_handle2)
then
utl_file.fclose(l_file_handle2);
end if;
end;
/ Received on Wed Apr 28 2004 - 04:19:42 CDT