一、用sys执行下面的命令。
0.
alter user sys identified by sys;1.
select owner, object_type from all_objects where object_name = 'UTL_FILE' ;
2.
grant execute on sys.utl_file to public;
3.
grant create any directory to atgcore_oreilly;
二、创建存储过程
create or replace PROCEDURE generator_file(dir in varchar2,out_file_name in varchar2)
is
txt_handle UTL_FILE.file_type;
var_tab varchar2(10);
begin
var_tab:=Chr(9);
execute immediate 'create or replace directory MY_DIR as '''||dir||'''';
execute immediate 'grant all on directory MY_DIR to public';
txt_handle := UTL_FILE.FOPEN('MY_DIR',out_file_name,'w');
UTL_FILE.PUT_LINE(txt_handle,'line'||var_tab||'item_number'||var_tab||'list_price'||var_tab||'sales_price');
for row_result in (select autoPr