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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
