Upon client's testing, it appears that the cause of error was one of the other stored procedure (named sp_tm_evaluation_set) that triggers an error ?DUPLICATE KEY ON INSERT detected.?, and upon proceeding to the concerned stored procedure sp_tm_evaluation_update, the error ?No MST is currently in progress, cannot declare another cursor? occurs.\n\n\nThe client added the rollback statement in the negative case part of the stored procedure sp_tm_evaluation_set and the ?No MST? ? error has been resolved.\n\n