The IS_OPEN function is used to test whether a file handle identifies an open file.
Applicability
This content applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support it.
Syntax
UTL_FILE.IS_OPEN (
file IN FILE_TYPE)
RETURN BOOLEAN;
Parameters
Parameter |
Explanation |
|---|---|
| file | byFOPENorFOPEN_NCHARReturns the handle of the activity file. |
Return value
Returns TRUE or FALSE.
Exceptions
INVALID_FILEHANDLE
Usage instructions
IS_OPEN only reports whether a file handle represents an open but not closed file, and does not guarantee that no operating system errors will occur when using the file handle.