Re: UTL_FILE package

From: Didier LENQUETTE <didier.lenquette_at_steria.fr>
Date: Wed, 20 Oct 1999 14:22:44 GMT
Message-ID: <UekP3.126$p%6.2892493@France.EU.net>

Hi !

DECLARE fichier UTL_FILE.FILE_TYPE;

BEGIN

     fichier := utl_file.fopen ('/u001/steria/divers', 'FRX', 'r');
     LOOP
         utl_file.get_line (fichier, ligne);
....
     END LOOP;

EXCEPTION WHEN NO_DATA_FOUND THEN
               dbms_output.put_line ('No data found');
          WHEN utl_file.VALUE_ERROR THEN
               utl_file.fclose (fichier);

END;
/

Mauro Pedone <mpedone_at_delos.it> a écrit dans le message : 7uju2h$p26$1_at_serv1.iunet.it...
> Hello!
> someone can help me?
>
> I need an example about Oracle UTL_FILE package,
> I must import a data file in Oracle with this package.
>
> Thank you to all!!
>
>
> Sorry for my english!
>
>
Received on Wed Oct 20 1999 - 09:22:44 CDT