SQL code is getting compiled even the columns are not matching in cursor declaration and fetch statement

Bala,

I think, the select statement is not the part of the CURSOR declaration syntactical check. Say, If you miss FOR in cursor declaration it will give you an error and can not be created the proc. Other case is that even you are not assigning the values to local variable, you will be able to create the procedure, however, it will show you an error message while executing.

---

Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.