Re: Porting code that does a raiseerror

[Srivats Chandrasekaran]

Hi,

We also had a similar problem like this. We developed a workaround for this, though i am sure if it is the optimal way of doing things.

we mimicked a table like sysusermessages in mysql and applied the same errorcode, message columns to the table.

And we have a generic function( Ex: getErrorMsg() ) which returns the message string from the table for a given input of the errorcode.

Inside the procedure

MAIN:BEGIN

IF ( some condtion )
select getErrorMsg( errorcode ) as Error;
leave main;
set nb_output_parameter = -1;
END IF;

END MAIN;

So every time we execute a procedure, we check the output_parameter . If it is -1 then we get the error message from the resultset and then throw an exception which otherwise raiserror throws.

Thks
Srivats.C