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