>I have this script that I run on a regular basis. I have a DECLARE tableIndexes CURSOR FOR that is inserted at several places in the script. But, if the script didn't run well on the last time, when I run the script again, I might have this error:
>
>"A cursor with the name 'tableIndexes' already exists."
>
>How can I make sure all cursor are cleaned before I start running the script.
Why you need CURSOR?
In 90% of time there is no need of it.
Sorry if I asked a question already answered, but I didn't follow the whole thread so far, I just stared.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.