Skip to Main Content
Forums

SQL & PL/SQL

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!

File is still open after fclose

MarwimSep 1 2010 — edited Sep 1 2010
Hello,

I open a file, read it line by line, close it and then I would expect that utl_file.is_open is FALSE. But when I want to delete the file after copying it into another folder I get
ORA-29283: invalid file operation

utl_file.is_open (handle) -> TRUE
utl_file.fclose (handle)
utl_file.is_open (handle) -> TRUE

I know that this can happen if you use fclose_all (see documentation), but it should not with fclose.

Has anyone encountered a similar problem and how am I supposed to search for the error?

Regards
Marcus
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 29 2010
Added on Sep 1 2010
6 comments
1,362 views