如题,code如下:declare
l_file utl_file.file_type;
begin
l_file := utl_file.fopen('E:\','20110216.xls','w');
utl_file.put_line(l_file,'PL/SQL操作EXCEL测试');
utl_file.fflush(l_file);
end;
ORA-29280: invalid directory path
ORA-06512: at "SYS.UTL_FILE", line 18
ORA-06512: at "SYS.UTL_FILE", line 424
ORA-06512: at line 5 20110216.xls文件在E盘根目录下。为什么会出现目录错误呢?
望大虾们解答之,谢谢!
l_file utl_file.file_type;
begin
l_file := utl_file.fopen('E:\','20110216.xls','w');
utl_file.put_line(l_file,'PL/SQL操作EXCEL测试');
utl_file.fflush(l_file);
end;
ORA-29280: invalid directory path
ORA-06512: at "SYS.UTL_FILE", line 18
ORA-06512: at "SYS.UTL_FILE", line 424
ORA-06512: at line 5 20110216.xls文件在E盘根目录下。为什么会出现目录错误呢?
望大虾们解答之,谢谢!
l_file utl_file.file_type;
begin
l_file:=utl_file.fopen('MYDIR','20110216.xls','w');
... ...
end;
/