Which of the following exception, FLOSE and FCLOSE_ALL raises?

Options
- UTL_FILE. WRITE_ ERROR
- UTL_FILE. READ_ ERROR
- UTL_FILE. READ_ ERROR
- UTL_FILE. VALUE_ ERROR


CORRECT ANSWER : UTL_FILE. WRITE_ ERROR

Discussion Board
UTL_FILE. WRITE_ ERROR

FCLOSE procedure closes an open file identified by a file handle. FCLOSE_ALL procedure closes all open file handles for the session. This should be used as an emergency cleanup procedure, for example, when a PL/SQL program exits with an exception. If there is buffered data yet to be written when FCLOSE and FCLOSE_ALL runs, then you may receive a WRITE_ERROR exception when closing a file.

Prajakta Pandit 02-23-2017 02:06 AM

Write your comments

 
   
 
 

Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement