-
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');
-
Is the utl_file parameter set in int.ora ?
Gert
-
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
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|