Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: UTL_FILE package

Re: UTL_FILE package

From: Didier LENQUETTE <didier.lenquette_at_steria.fr>
Date: Wed, 20 Oct 1999 14:09:15 GMT
Message-ID: <f2kP3.119$p%6.2886798@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:09:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US