PL/SQL - Exception Handling for utl_file

From: david davis <ddoralist_at_hotmail.com>
Date: Wed, 26 Feb 2003 08:34:17 -0800
Message-ID: <F001.0055A2FD.20030226083417@fatcity.com>

Perhaps someone on the list will know the answer as I have not found anything in the manual (though I might have missed it).

If a procedure is performing file i/o to more than one file and an exception is raised related to the utl_file package how can I determine which file had the exception?

eg.

begin
...

utl_file.put_line(fh_extract,v_extract_dataline); utl_file.put_line(fh_log,v_logmsg);
...

exception
when utl_file.write_error then
  ...
end;

David

---

The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: david davis
  INET: ddoralist_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Feb 26 2003 - 10:34:17 CST