A cursor with the name 'CURSOR_LIST' does not exist

Shahriar Nikkhah8y ago

SCRIPT out both SP and check the difference

Alok Gupta8y ago

Hi Jaya,

Same Store procedure smoothly working in Production database ,but in operation database it is not working.

Please suggest any other solution.

Thanks

Jayakumar Balasubramaniam8y ago

Hi, The error itself clearly states that you don't have such cursor in your procedure. Its a regular copy paste issue i believe, so please check your cursor declaration and cursor definition and cursor invoking using the same name.