UTL_FILE

[rcalzone]

Using this command, what causes the INVALID_OPERATION exception to be raised?

DECLARE
V_FILE_ID UTL_FILE.FILE_TYPE;

BEGIN
V_FILE_ID := UTL_FILE.FOPEN ('i:\development\bob\','ftsccf.prn','r');

[denevge]

Is the utl_file parameter set in int.ora ?

Gert

[mber]

This means file couldn't be opened or operated as requested.
Probably the drive access is not successfully, check the init.ora file permission and file name also.

Take care

[m1l]

Also in the init.ora, there is a parameter

utl_file_dir

Which will have to be set to the directory you are trying to write to and don't forget that you can only write to the machine with the Oracle instance on, not your local PC, so if 'i:\development\bob' is a local drive, it wont work either.