Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 35.1Mb
PDF (A4) - 35.2Mb
Man Pages (TGZ) - 256.4Kb
Man Pages (Zip) - 361.2Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

MySQL 5.7 Reference Manual  / ...  / SQL Statements  / Compound Statements  / Condition Handling  /  Condition Handling and OUT or INOUT Parameters

13.6.7.8 Condition Handling and OUT or INOUT Parameters

If a stored procedure exits with an unhandled exception, modified values ofOUT andINOUT parameters are not propogated back to the caller.

If an exception is handled by aCONTINUE orEXIT handler that contains aRESIGNAL statement, execution ofRESIGNAL pops the Diagnostics Area stack, thus signalling the exception (that is, the information that existed before entry into the handler). If the exception is an error, the values ofOUT andINOUT parameters are not propogated back to the caller.