Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: UTL_FILE package
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