MySQL Forums
Forum List  »  Stored Procedures

Re: Declare Cursor -- simple failure
Posted by: Michael Ayres
Date: March 15, 2016 09:13AM

Yes thanks. I did get it to work by putting in a procedure and code block. My curiosity why it did not work if in just a single SQL statement, with no other code whatsoever. Could be something about the scope of the declared cursor variable name only being visible with a block within which it is declared.

Tks again

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
Michael.Ayres@ucop.edu | (510) 987-9459 | (415) 999-2049 Mobile

Options: ReplyQuote


Subject
Views
Written By
Posted
2762
March 14, 2016 01:10PM
Re: Declare Cursor -- simple failure
881
March 15, 2016 09:13AM


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.