select into v_variable from table

Hi Gurus,

I added this to my stored procedure but for some reason I encountered an error. It went well if I deleted this line and error out if I added it.

this is the script.

SELECT SEQ_NUMBER INTO v_employee_id FROM tclmdocnumber WHERE code_type = 'EMP_ID'

Both SEQ_NUMBER and v_employee_id are INTEGER