Regarding UTL_FILE Package in PLSQL

[dkarthick]

How to execute UTL_FILE Package in plsql?

[helpme]

Hi dkarthick

UTL_FILE package are used inside the procedure itself. So you write a procedure, use UTL_FILE package there and call the procedure from any other function or procedure as you do normally.

Tk Care...

[goudelly]

Hi,

UTL_FILE is pl/sql packsge.

Eg:

Decalre
cursor c1 is select * from emp;
v_file utl_file.file_t ype;
begin
v_file := utl_file.fopen( 'c:\utl_dir','e mp.txt','w');
for r1 in c1 loop
utl_file.put_li ne(v_file,r1.em pid||'|'||r1.en ame||'|''sal||

end loop;
ult_file.fclose (v_file);
end;

Complie this and execute it..


Thanks,

Mohan Reddy G