MySQL Forums
Forum List  »  Stored Procedures

Re: how to declare cursor in middle of stored procedure
Posted by: Peter Brawley
Date: October 19, 2016 09:26AM

> can we declare cursors in middle of the stored program

As the manual says, DECLARE must precede all code in its block, so to declare a cursor mid-routine, create a block for it.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: how to declare cursor in middle of stored procedure
1025
October 19, 2016 09:26AM


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.