 | | | Getting SQLSTATE in stored procedure | Getting SQLSTATE in stored procedure 2005-05-15 - By Ken Resander
Back
How do I get SQLSTATE in a procedure?
For example:
CREATE PROCEDURE myproc()
BEGIN
DECLARE CURSOR c1 Select.......;
....
DECLARE var1, var2,...varN INT;
OPEN c1;
LOOP
FETCH c1 INTO var1, var2, VarN;
<need SQLSTATE, what should go in here?>
END LOOP;
CLOSE c1;
END;
SQL 1999 standard defines a statement GET DIAGNOSTICS EXCEPTION... for this;
DB2 uses a special predefined variable SQLSTATE (I think), but what is needed
for MySQL?
Earn $52 per hosting referral at Lunarpages.
|
|
|