Utl_file.

From: Alexxx12 <member14441_at_dbforums.com>
Date: Fri, 07 Feb 2003 22:33:22 +0000
Message-ID: <2499540.1044657202_at_dbforums.com>


Hi:

[Quoted] I am runing this scrip:

DECLARE
  fileHandler UTL_FILE.FILE_TYPE;
BEGIN
  fileHandler := UTL_FILE.FOPEN('c:\temp', 'myoutput.txt', 'W');   UTL_FILE.PUTF(fileHandler, 'Look ma, I''m writing to a file!!!\n');   UTL_FILE.FCLOSE(fileHandler);
EXCEPTION
  WHEN utl_file.invalid_path THEN

     raise_application_error(-20000, 'ERROR: Invalid path for file.'); END; and I get this error:

DECLARE
*
ERROR at line 1:
ORA-20000: ERROR: Invalid path for file. ORA-06512: at line 9

[Quoted] [Quoted] The path is correct. Why am I getting this error??

Alex.

--
Posted via http://dbforums.com
Received on Fri Feb 07 2003 - 23:33:22 CET

Original text of this message