Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-20100 Invalid File Path

62896May 18 2004 — edited May 18 2004
I 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;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 15 2004
Added on May 18 2004
3 comments
917 views