Re: PL/SQL Newbie Help / Stored Procedure

"Kim Goldenberg" <kshorty_at_phat.com> wrote in message news:db0be6d6.0205131124.2c39fffc_at_posting.google.com...
> What would happen if one row had an incorrect value and kicked back.
> Would the entire insert or update fail. I was hoping to use a pl/sql
> cursor to increase the logging and error checking capability.

The statement involved would fail, whether that updates 1 or 1 million records.
You might consider moving the error checking to a before insert or update for each row trigger, and log errors through autonomous transactions. The trigger would raise an exception, the exception handler would call your error logging, and if you don't explicitly rollback yourself, the transaction will proceed.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address