MySQL Forums
Forum List  »  Stored Procedures

Advanced Search
New Topic

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.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
how to declare cursor in middle of stored procedure
7096
BHANU PRATAP MUNAGALA
October 19, 2016 03:36AM
Re: how to declare cursor in middle of stored procedure
1467
Jon Stephens
October 19, 2016 06:21AM
Re: how to declare cursor in middle of stored procedure
1264
BHANU PRATAP MUNAGALA
October 19, 2016 08:22AM
Re: how to declare cursor in middle of stored procedure
1097
Peter Brawley
October 19, 2016 09:26AM
Re: how to declare cursor in middle of stored procedure
999
BHANU PRATAP MUNAGALA
October 19, 2016 10:04AM
Re: how to declare cursor in middle of stored procedure
3180
Peter Brawley
October 19, 2016 11:10AM
Re: how to declare cursor in middle of stored procedure
1398
Rick James
October 19, 2016 11:47PM


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.