Error checking // List of all errors

[Ivan Smahin]

Hello Ruslan,

Friday, September 21, 2007, 1:04:21 PM, you wrote:

> On 21/9/07 12:48 PM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:

>> I suppose this is not possible for the moment because in the
>> exception I , for the moment, need to put the when....
>> 
>> 
>> or could this work
>> 
>> exception
>> when 50000 then
>> call sp_errorcheck();
>> when others then
>> call sp_errorcheck();
>> end
>> 
>> hmm, this won't work
>> 
>> How do I pass the 'exception number' to the procedure sp_errorcheck ?

> At least as

> exception
> when 50000 then
>     call sp_errorcheck(5000);
> when others then
>     call sp_errorcheck();
> end


Need to think about something like this:

...
when others then
    Set @lastErr = SELECT LAST_ERROR()
    call sp_errorcheck( @lastErr );
end

Probably it exists already in some form...

-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com