Multiple choice technology databases

Which of the following exceptions are valid regarding util_file package

  1. INVALID_OFFSET

  2. VALUE_ERROR

  3. ACCESS_DENIED

  4. INVALID_MAXLINE_SIZE

  5. INVALID_FILENAME
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

INVALID_MAXLINE_SIZE is a valid UTL_FILE exception raised when the MAX_LINESIZE parameter in FOPEN or FOPEN_NCHAR exceeds implementation limits. Other valid exceptions include INVALID_PATH, INVALID_MODE, INVALID_FILEHANDLE, and WRITE_ERROR, but INVALID_OFFSET, VALUE_ERROR, and ACCESS_DENIED are not standard UTL_FILE exceptions.

Keep practicing — related questions