Deleting records from cursor inside Stored Procedure.

[sudeep s]

I have a cursor which selects records from Table "A" and based on the record fetched, it first updates table "B" and then deletes record from Table "A"(the same table cursor picks the record from) inside one single loop. I wanted to check if this approach is fine . Kindly advice