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: Help with utl_file package

Re: Help with utl_file package

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Sun, 20 Jun 1999 10:27:33 +0200
Message-ID: <7ki8ll$avq$1@weber.a2000.nl>


Stephane Gouin wrote
> WHEN OTHERS THEN
> DBMS_OUTPUT.PUT_LINE('other stuff');
> UTL_FILE.FCLOSE(file_handle);
> END;
You'd better not catch WHEN OTHERS, or use

               DBMS_OUTPUT.PUT_LINE(sqlerrm);

Arjan. Received on Sun Jun 20 1999 - 03:27:33 CDT

Original text of this message

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