How to exit from stored procedure.

How to exit from stored procedure.

\"\" The solution is very simple. We can use LEAVE statement to quit from any labeled flow control construct (LOOP, WHILE, REPEAT) –

 

In our case it is enough to place named label before the BEGIN…END clause and call LEAVE statement –

Leave a Reply

Your email address will not be published. Required fields are marked *