MySQL Forums
Forum List  »  Stored Procedures

Re: Declare Cursor -- simple failure
Posted by: Michael Ayres
Date: March 14, 2016 03:42PM

I got this to work by putting in a stored procedure; though may examples show a cursor within a stored procedure, nowhere does it say it needs to be between a block, not even within a stored procedure, directly from a sql statement(s). I don't even know about the command window. My stupid maybe, but background and training says never assume anything, that a curser must be within a begin end block, or procedure (if that is even true). Whatever...

Michael Ayres
Senior Technical Project Manager
Cyber Security Coordination Center

Michael Ayres, MS, PMP, ACP, CISSP
University of California Office of the President (contractor)
1111 Franklin Street #7109 Oakland, Ca.94607 | (510) 987-9459 | (415) 999-2049 Mobile

Options: ReplyQuote

Written By
March 14, 2016 01:10PM
Re: Declare Cursor -- simple failure
March 14, 2016 03:42PM

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.