ORA-20100 Invalid File Path
62896May 18 2004 — edited May 18 2004I am trying to output a line into a text file
Here is the procedure. Simple enough but throwing the error ORA 20100 Invalid file path. I am using Oracle 9i and its a standard database. The database resides on the same machine. Please Help
PROCEDURE WriteInErrFile
(
OUT_PARAM OUT NUMBER
)
as
FileHandle UTL_FILE.FILE_TYPE;
ErrFilePath varchar2(3) := 'C:\';
vPath varchar2(100);
ErrFileName varchar2(50) := 'SQLLOG.txt';
ErrOpenMode varchar2(1) := 'a';
BEGIN
FileHandle := UTL_FILE.FOPEN( 'C:\SQLLOG', 'SQLLOG.txt', 'a' );
if UTL_FILE.IS_OPEN(FileHandle) then
UTL_FILE.PUT( FileHandle, 'NICK' );
UTL_FILE.NEW_LINE(FileHandle);
UTL_FILE.FFLUSH(FileHandle);
UTL_FILE.FCLOSE(FileHandle);
else
DBMS_OUTPUT.PUT_LINE(NOT GOOD');
end if;
OUT_PARAM := 0;
RETURN;
EXCEPTION
when UTL_FILE.INVALID_PATH then
OUT_PARAM := 1;
raise_application_error(-20100,'INVALID FILE PATH');
when UTL_FILE.INVALID_MODE then
OUT_PARAM := 2;
raise_application_error(-20101,'INVALID_MODE');
when UTL_FILE.INVALID_OPERATION then
OUT_PARAM := 3;
RAISE_APPLICATION_ERROR(-20102,'INVALID_OPERATION');
when UTL_FILE.INVALID_FILEHANDLE then
OUT_PARAM := 4;
raise_application_error(-20103,'INVALID_FILEHANDLE');
when UTL_FILE.WRITE_ERROR then
OUT_PARAM := 5;
RAISE_APPLICATION_ERROR(-20104,'WRITE_ERROR');
when UTL_FILE.READ_ERROR then
OUT_PARAM := 6;
RAISE_APPLICATION_ERROR(-20105,'READ_ERROR');
OUT_PARAM := 7;
when UTL_FILE.INTERNAL_ERROR then
RAISE_APPLICATION_ERROR(-20106,'INTERNAL_ERROR');
END;