IS_OPEN

The IS_OPEN function checks whether a file handle is still open, which is often used to decide whether to call FCLOSE in case of an exception.

Syntax

UTL_FILE.IS_OPEN(file)

Parameters

Return value

The IS_OPEN function returns a value of the BOOLEAN type. If the return value is TRUE, the file handle is valid and the corresponding file is open. If the return value is FALSE, the file is closed or the file handle is invalid.

Considerations

• The file handle passed to IS_OPEN must be obtained from a successful call to FOPEN or FOPEN_NCHAR. An uninitialized or released handle will cause the function to return FALSE.
• Unlike most procedures in the UTL_FILE package, IS_OPEN does not typically raise an exception. Its design purpose is to safely query the status, so it will return FALSE instead of an error even if the handle is invalid.