How can I check if the cursor in my stored procedure has been defined or opened

[Terry Xia]

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