Home » SQL & PL/SQL » SQL & PL/SQL » BULK COLLECT
BULK COLLECT [message #292768] Wed, 09 January 2008 16:48 Go to next message
uicmxz
Messages: 48
Registered: July 2006
Member
Is it possible to get more information about the record that failed during execution FORALL statement? Can be user defined exceptions created to catch additional info about failed record?
The SAVE EXCEPTIONS collection only return error code and error message. I have to catch certain fields from the failed records.
Re: BULK COLLECT [message #292787 is a reply to message #292768] Wed, 09 January 2008 20:36 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/tuning.htm#i49099

Use %BULK_EXCEPTIONS(i).ERROR_INDEX to get a reference back into your original collection.

Ross Leishman
Re: BULK COLLECT [message #293020 is a reply to message #292787] Thu, 10 January 2008 11:00 Go to previous messageGo to next message
uicmxz
Messages: 48
Registered: July 2006
Member
Can I use %BULK_EXCEPTIONS(i).ERROR_INDEX in Oracle 8i?
Re: BULK COLLECT [message #293025 is a reply to message #293020] Thu, 10 January 2008 11:28 Go to previous message
Michel Cadot
Messages: 64127
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No but SAVE EXCEPTIONS does not exist either.

Regards
Michel
Previous Topic: customer data retrieval
Next Topic: adding zeros to the left of a number in the number column
Goto Forum:
  


Current Time: Wed Dec 07 06:44:44 CST 2016

Total time taken to generate the page: 0.05608 seconds