oracle¶ÁдÎı¾Îļþ

create or replace procedure test
is
v_file_handle utl_file.file_type;
v_file_name varchar2(30);

begin

  v_file_name:='f.txt';
 
  v_file_handle:=utl_file.fopen('orl_dir',v_file_name,'w');
  utl_file.put_line(v_file_handle,'test');
  utl_file.fclose(v_file_handle);

end;
Ö´Ðкó±¨Ï´íÎó£º

ORA-29280: Ŀ¼·¾¶ÎÞЧ
ORA-06512: ÔÚ "SYS.UTL_FILE", line 33
ORA-06512: ÔÚ "SYS.UTL_FILE", line 436
ORA-06512: ÔÚ "FZM.TEST", line 12
ORA-06512: ÔÚ line 1

ÔÚ±¾µØ½¨Á¢µÄĿ¼¶¼ÊÚÓèÁËȨÏÞ¡£
²»ÖªÎªÊ²Ã´±¨´í£¿£¿

---

v_file_name:='f.txt'; »»³É¾ø¶Ô·¾¶ÊÔÒ»ÊÔ

---

¾ø¶Ô·¾¶Ò²²»ÐУ¬»¹ÊÇͬÑùµÄ´íÎó