Toad World® Forums

Unable to stop a loop statement

Dear Debbie

I have been unable to stop a loop

I have had several mails

The process have not stopped

How does I stopped the loop

My email box is getting full

Please helpe I have received over 300 mails within 2hours . The process have not ended!

Hi...
the number of loop is equal to rows count in dataset from the SQL you've set in loop_data_1...
If the loop seems to never ending, your sql probably generate too much rows...

Regards...

Franck