OraFAQ Forum: SQL & PL/SQL » BULK COLLECT

Home » SQL & PL/SQL » SQL & PL/SQL » BULK COLLECT

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

BULK COLLECT [message #292768]

Wed, 09 January 2008 16:48

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

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

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

Michel Cadot
Messages: 68767
Registered: March 2007
Location: Saint-Maur, France, https...

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Aug 26 05:56:42 CDT 2025