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