MySQL Forums
Forum List  »  Stored Procedures

How can I check if the cursor in my stored procedure has been defined or opened
Posted by: Terry Xia
Date: April 07, 2019 08:19AM

I want to check if CurTest cursor exists in msyq ? how to encode the scripts in the following sample, many thanks!


Declare CurTest cursor for select * from tablename ;
open cursor ;
...

I want to check if CurTest cursor exists in system in the line ? how to encode the scripts here

Options: ReplyQuote


Subject
Views
Written By
Posted
How can I check if the cursor in my stored procedure has been defined or opened
1243
April 07, 2019 08:19AM


Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.