-
Appending data to file by using utl_file
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;
/
Cheers!
OraKid.
-
Re: Appending data to file by using utl_file
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?.
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, ....)).
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|