I have a problem working with the stored procs.
The stored proc looks like this
create procedure unit_swap()
BEGIN
DECLARE b INT DEFAULT 7;
DECLARE c INT;
DECLARE CONTINUE HANDLER FOR 1176 SET b = 1111;
DECLARE CONTINUE HANDLER FOR NOT FOUND, SQLEXCEPTION, SQLWARNING SET b =
1111;
UPDATE EMP SET STYLE='CCCC' WHERE ID='999';
IF b = 1111 THEN
INSERT INTO EMP (ID) VALUES ('999');
END IF;
COMMIT;
END;
The problem here is that even if update fails, meaning even if ID '999'
doesn't exist, MySQL doesn't report any error or warning (NOT FOUND error
handler is not catching this). So I have no way to declare error handler for
this statement and then taking the action accordingly. (INSETTING OR ANY
OTHER THING)
Any help on this is extremely useful.
Thank you
sujay
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
