select variable

 I am trying to select in a loop a number (214) of columns for one specific ROWID but getting errors, this is what I have been trying, this is part of a stored procedure.

The column names are test1, test2, test3, test4.......test214

v_test_fail  NUMBER := 1; 

LOOP    
v_test_no := 'test' || TRIM(TO_CHAR(v_test_fail));
select v_test_no INTO v_test_gen from ns_insprep where rowid = v_rowid;        
IF UPPER(v_test_gen) = 'FAIL' THEN        
UPDATE common       
SET test_fail = 'F'        
WHERE TRIM(idno) = TRIM(v_user_lic) AND TRIM(macno) = TRIM(v_insp_macno);         
EXIT;