March 8, 2017 at 6:13 am
I have stored procedure where cursor called repeatedly very Monday morning between 4:30 and 5 am and proc hangs across all platforms..It works fine other times. The only thing I noticed was close cursor command is missing and only deal locate cursor is applied.I'm not able find where it is going wrong.Any suggestions would be welcome.
March 8, 2017 at 6:28 am
savibp3 - Wednesday, March 8, 2017 6:13 AMI have stored procedure where cursor called repeatedly very Monday morning between 4:30 and 5 am and proc hangs across all platforms..It works fine other times. The only thing I noticed was close cursor command is missing and only deal locate cursor is applied.I'm not able find where it is going wrong.Any suggestions would be welcome.
Suggestion 1: rewrite the proc so that no cursor is called
Suggestion 2: post the code, so that we don't have to invoke the occult in order to have a chance at answering your question in any detail.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
March 8, 2017 at 7:09 am
This appears to be a duplicate posting.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply