Hello.
There was a question about exceptions recently. The answer might be
helpful:
http://lists.mysql.com/mysql/188048
Leigh <ktulu@stripped> wrote:
> Hi All,
>
> I'm currently working on porting a database form Informix 9.2 to MySQL 5
> in order to determine the suitability of MySQL for our application. At
> the moment, I'm stuck with one of our stored procs that contains the
> following lines:
>
> -- If duplicates are detected, raise an error
> IF count > 1 THEN
> RAISE EXCEPTION -746, 0, 'Duplicate mapping: code "' || p_code ||
> '", cust "' || p_cust_code || '"';
> END IF;
>
> Under Informix, this IF statement raises a user defined JDBC Exception
> (the code "-746" is for user defined errors). Is there any way of doing
> a similar thing in MySQL?
>
> If you need any more information, I'm happy to provide it. Thanks in
> advance!
> Regards,
> Leigh
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
