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
Karma: 0
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: 3727
Registered: October 2005
Location: Melbourne, Australia
Karma: 0
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
Karma: 0
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: 65153
Registered: March 2007
Location: Nanterre, France, http://...
Karma: 0
Senior Member
Account Moderator
No but SAVE EXCEPTIONS does not exist either.

Regards
Michel
Previous Topic: customer data retrieval
Next Topic: function is said to be return only one value but ....?
Goto Forum:
  


Current Time: Tue Aug 22 10:02:17 CDT 2017

Total time taken to generate the page: 0.06017 seconds