Try to declare v_new_locn in the main block declare section. Sub block variables are not visible in main block. Hope I'm right.