close existing cursor

• vineetbhargav

  Mr or Mrs. 500

  Points: 522

  More actions

  July 26, 2011 at 9:15 am

  #100402

  Dear All

  I have one cursor called as Curr_Mapp, i have executed my procedure using UI, when i executed my procedure throws an error, and i was not handling closing or dellocation of cursor in my catch block,

  now what happening is when im running the procedure its giving me the error : cusror with name 'Curr_mapp already exist' even if i'm making the call from diff SPID

  I dont have right to run system procedure as well as i have closed all the connections from UI as well DB from where the call to this cursor is made..

  but its of no use its still throwing the error.Is there any way out to handle this situation apart from changing cursor name.

  I'm using sql server 2005

  Thanks for your help in advance.

  Regards

  Vineet

  Thanks And Regards
  Vineet Bhargava
  vineetbhargav@gmail.com

• GSquared

  SSC Guru

  Points: 260824

  More actions

  July 26, 2011 at 9:18 am

  #1358599

  Is the cursor declared as "local"?

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon