Hello.
There was a question about exceptions recently. The answer might be helpful: http://lists.mysql.com/mysql/188048 Leigh <[EMAIL PROTECTED]> 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 / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]