Home » SQL & PL/SQL » SQL & PL/SQL » using UTL_FILE for bulk_exceptions (10g)
using UTL_FILE for bulk_exceptions [message #418187] Thu, 13 August 2009 05:34 Go to next message
Messages: 7
Registered: June 2009
Junior Member
Hi all,

May I please ask for assistance on how to incorporate UTL_FILE into my code so that I can write bulk_exceptions (from bulk insert perfomed) into a text file (OS level) instead of inserting in another table?

I would also appreciate other suggestions other than using UTL_FILE, if there are any.

Many thanks
Re: using UTL_FILE for bulk_exceptions [message #418191 is a reply to message #418187] Thu, 13 August 2009 05:59 Go to previous message
Michel Cadot
Messages: 63917
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I suggest you show us what you want to do and not post a very general question otherwise you will have a very general answer.

Search in http://www.oracle.com/technology/oramag/index.html, Steven Feuerstein wrote several articles on the subject of bulk operations.

Previous Topic: Problems with ElseIf
Next Topic: Error Msg :ORA-01779: cannot modify a column which maps to a non key-preserved table
Goto Forum:

Current Time: Tue Oct 25 00:54:42 CDT 2016

Total time taken to generate the page: 0.07700 seconds