—————for create os file————

create or replace procedure create_file is
dosya utl_file.file_type;
v_dosya varchar2(20):=’deneme’;
begin
dosya := utl_file.fopen(‘ORHAN_DIR’,v_dosya,’W’);
if utl_file.is_open(dosya) then
utl_file.fclose_all;
dbms_output.put_line(‘Closed All’);
end if;
end create_file;

———–for run———————–
begin
username.create_file;
end;

———-for delete—————–

exec dbms_backup_restore.deletefile(‘u01/deneme’);

Reklamlar