文章列表
创建文件目录：
create or replace directory BLOBDIR as 'c:\oracleLog\';
grant read,write on directory BLOBDIR to ects;
GRANT EXECUTE ON utl_file TO ects;
select * from ALL_DIRECTORIES;
文件读取：
CREATE OR REPLACE PROCEDURE P_WRITE_EMP AS
V_FILE UTL_FILE.FILE_TYPE;
V_BUFFER VARCHAR2(32767);
BEGIN
V_FILE := ...