>I'm not familar with the way that Oracle handles error so I can't comment. I will be the first to say that SQL Server does have a very primitive error handling mechanism but it's what we've got.
>
>-Mike
Mike,
PL/SQL has something called an EXCEPTIONS clause for each PL/SQL block of code. In this block, you can define something like a case statement to do different things for different errors. It is something like VFP's Error event in that control is transfered immediately to the exceptions block. However, the main difference is that once a block of code exceptions, you can't return to the code that follows the code that caused the exception.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao