select into v_variable from table

MIKEM's profile image MIKEM posted 7 months ago in Running SQL scripts Permalink

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

Please login to leave a reply, or register at first.