utl_file问题

吁风云

使用utl_file写文件\r\n开始时报错：\r\ndeclare\r\n*\r\nERROR at line 1:\r\nORA-06510: PL/SQL: unhandled user-defined exception\r\nORA-06512: at \"SYS.UTL_FILE\", line 98\r\nORA-06512: at \"SYS.UTL_FILE\", line 157\r\nORA-06512: at line 6\r\n\r\n在initSid.ora中增加目录\r\nUTL_FILE_DIR = \"/opt/tmp\"后，\r\n\r\n报错：\r\ndeclare\r\n*\r\nERROR at line 1:\r\nORA-06510: PL/SQL: unhandled user-defined exception\r\nORA-06512: at \"SYS.UTL_FILE\", line 101\r\nORA-06512: at \"SYS.UTL_FILE\", line 157\r\nORA-06512: at line 6\r\n\r\n请各位大侠襄助。

寒江獨釣

通往utl_file的路径一定要正确地列在init.ora文件里面(utl_file_dir=path). 而且路径的大小写一定要分明.