Multiple choice technology databases

The exception INVALID_FILEHANDLE can occur when the following procedures are called?

  1. FCLOSE

  2. GET_LINE

  3. IS_OPEN

  4. 1,2

  5. All of the above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The INVALID_FILEHANDLE exception is raised by UTL_FILE procedures like FCLOSE and GET_LINE when they receive an invalid or uninitialized file handle. Conversely, the IS_OPEN function evaluates whether a handle is open and returns a boolean value instead of raising this exception, making the combination 1,2 correct.

Keep practicing — related questions