Printable View
I am using oracle 8.1.7 .
I have written a stored procedure which writes data in to a file by using utl_file.
now i want to append some data at the end of the first line in the same file. How can we do it?. Can we move the file pointer to whatever the position just we do it in C (like by fseek()) ?
thank u
this is just an example
declare
fname VARCHAR2(40);
floc VARCHAR2(20) := '/opt/oracle/utldir'; -- file location
ftype UTL_FILE.FILE_TYPE;
cursor cur_accstmt is select a, b from testme;
begin
dbms_output.put_line('Start time : '||to_char(sysdate,'HH24:MI:SS'));
fname := 'acctstmt'||sysdate||'.dat';
dbms_output.put_line(fname);
ftype := utl_file.fopen(floc,fname,'w');
For i in cur_accstmt loop
utl_file.put_line(ftype,
i.A||'|'||
i.B
);
utl_file.new_line(ftype,0);
end loop;
if utl_file.is_open(ftype) then
utl_file.fclose(ftype);
end if;
dbms_output.put_line('End time : '||to_char(sysdate,'HH24:MI:SS'));
end;
/
AFAIK you can't do that by UTL_FILE, at least not in 8.1.7. It is possible in 9i, by reading the original file, storing changed contents in new file and finaly by renaming new file to original file with overwrite option (UTL_FILE.FRENAME(overwrite=>TRUE, ....)).Quote:
Originally posted by rk0000
I am using oracle 8.1.7 .
I have written a stored procedure which writes data in to a file by using utl_file.
now i want to append some data at the end of the first line in the same file. How can we do it?.