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.

Report message to a moderator

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: 3728
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

Report message to a moderator

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?

Report message to a moderator

Re: BULK COLLECT [message #293025 is a reply to message #293020] Thu, 10 January 2008 11:28 Go to previous message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No but SAVE EXCEPTIONS does not exist either.

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Apr 20 00:29:35 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.