今天在执行一个过程时报了ORA-29280: invalid directory path错误
scott@TEST>exec exportddl_all('123');
BEGIN exportddl_all('123'); END;
*
ERROR at line 1:
ORA-29280: invalid directory path
ORA-06512: at "SYS.UTL_FILE", line 33
ORA-06512: at "SYS.UTL_FILE", line 436
ORA-06512: at "SCOTT.EXPORTDDL", line 15
ORA-06512: at "SCOTT.EXPORTDDL_ALL", line 5
ORA-06512: at line 1
按照提示查看过程相应的行,发现是在utl_file.fopen中的目录名utl_dir使用了小写,改为大写后问题解决。这也要求大小写,Oracle真够死心眼的
l_file := utl_file.fopen('utl_dir', p_filename||'.sql', 'a', 1000);
l_file := utl_file.fopen('UTL_DIR', p_filename||'.sql', 'a', 1000);
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/498744/viewspace-277831/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/498744/viewspace-277831/