Error checking

[Bart Pietercil]

On 21-sep-07, at 11:11, Ruslan Zasukhin wrote:

> On 21/9/07 11:19 AM, "Bart Pietercil" <bart.pietercil at gmail.com>  
> wrote:
>
>> exception
>> when 50000 then
>>       print 'dummy';
>>      when others then
>>        print 'something went wrong';
>> end
>
> I checking now grammer, yes right now it requires that present
>
>     WHEN err
>
> Then only
>     WHEN others
>
> I will make WHEN err to be optional.

Thinking about Exception checking in OO way is it possible to pass  
the error checking to an ErrorChecking Stored Procedure

create or replace spSomeProc()
Begin
	.....
Exception
	call sp_ErrorCheck();
End


create or replace sp_ErrorCheck()
Begin
	case

	case

	....

end

Is this possible ? If yes were can I find the list of all possible  
errors ?

Thx

Bart