Re: Control Structures

Scott wrote:
>
> G'day
>
> Is there any way to simulate an ada-like case statement in pl/sql?
>
> I have a form level on-error trigger to catch and customize certain
> error messages, however an if-elsif-elsif....end if structure seems to
> catch only the first message it encounters, and exits the if control
> structure.
>
> Scott.

if-elseif-elseif-end if to catch just one if-endif if-endif etc to catch all that apply

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse