select * from all_directories;--查看创建的目录
drop directory my_dir;--删除目录
create or replace directory exp_dir as '/tmp'; --创建目录
grant read, write on directory exp_dir to xe; --授权
CREATE OR REPLACE PROCEDURE test_club IS
--v_module_name VARCHAR2(35) := 'Daily_Settlement_Deskbank_File';
v_transacationtnr NUMBER := 1;