How to exit an SP in a midway if some conditions are met? is LEAVE the only option? Also in SP manual states that if leave is used all the open cursors will be closed in that block, if so is there some other means by which we can exit the SP midway without closing the cursors?
You want to return a result set from the SP?
In that case you should be able to LEAVE, because AFAIK this only closes real cursors.