cursors with variables

need to have values set to the variables before declaring the cursor
i had a declaration section with out settings and this failed