SProc multi-row result handling
Posted by:
Mike S
Date: December 06, 2008 02:50PM
I am uncertain if SProcs can return more than one row (error 1172 seems to occur).
Consequently I coded a DECLARE CONTINUE HANDLER FOR 1172 but (I using MySql 5.1.11 believe) this
http://bugs.mysql.com/bug.php?id=8153 bug has cropped up.
I'm a little reluctant to update my version (http://dev.mysql.com/doc/refman/5.1/en/windows-upgrading.html) as it seems difficult and I have read elsewhere that using error handling is not as great practice as using IF - THEN flows.
Thoughts?
Subject
Views
Written By
Posted
SProc multi-row result handling
2660
December 06, 2008 02:50PM
1452
December 06, 2008 04:04PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.