A parameterized cursor are static cursor which will take passed in parameter values when they are opened. Parameterized can only reference to its own parameter parameterized cursor can not reference to local variable. Indeed, If treatment declared in specification not defined in body will via compilation mistake declaring:- "process declared http://chancesjzim.blogdon.net/mysql-homework-help-for-dummies-7457818