UTL_FILE-how to test if end of file?

Dúvidas, dicas e truques de PL/SQL. Aqui também vão assuntos relacionados a pacotes, triggers, funções, Java-Stored Procedures, etc
  

Poston Fri, 29 Apr 2005 9:30 am

Galera, in the package UTL_FILE, is there any way for me to test for end of file..something like EOF?

Grateful
sydfilho
Location: porto alegre

Poston Fri, 29 Apr 2005 11:35 am

Uses EXCEPTION WHEN NO_DATA_FOUND!!!

List of Exceptions: INVALID_PATH -invalid file name or directory INVALID_MODE -aperture mode parameter is invalid INVALID_FILEHANDLE -invalid file specifier INVALID_OPERATION-the file cannot be opened or the operation is invalid READ_ERROR -an operating system error occurred while reading a file WRITE_ERROR-an operating system error occurred while recording a file INTERNAL_ERROR -unspecified error in PL/SQL NO_DATA_FOUND-in this case, is triggered when the end of the MP3 towards WAM switchest is encountered in processing sequential read from a text file
dr_gori
Location: Portland, OR USA

Thomas F. G

Você já respondeu a dúvida de alguém hoje?
http://glufke.net/oracle/search.php?search_id=unanswered


  • See also
    Replies
    Views
    Last Post