>>There have been times when I have been tempted to use the same name as a previous cursor. I don't like using q1, q2, etc. because they have no meaning. After trying to give meaningful names to all my queries, there are times when its just as easy to use the same name as a previous query.
>>
>>What are your feelings about that?
>
>I'm okey with it. :)
>Seriously, it depends. If you mean
Select ... FROM mycursor ... INTO CURSOR mycursor
then I don't do that because it makes debugging harder.
Its actually pretty rare that I need to use it. Probably the fact that I need to use the same cursor name is pointing to the fact that I need to refactor and simplify my selects.