No luck at all :( , as i still get the same error.

Can some one possibly code the correct insert statement for me please?

for rec in (select * from tenants)
loop

DECLARE
ten_rec tenants%ROWTYPE;
BEGIN
SELECT * INTO ten_rec
FROM tenants
WHERE tenant_id = tenant_id;
INSERT INTO tenant_histories(H_SURNAME,H_GIVEN_NAME,H_CONTACT_NUM,H_REF_CONTANCT_NUM,H_OCCUPTION_DATE,H_TENANT_C OMP_ADD,H_TENANT_COMP_NAME,TENANT_ID)
VALUES (ten_rec.surname, ten_rec.given_name, ten_rec.contact_num, ten_rec.ref_contact_num,ten_rec.occupation_date, ten_rec.tenant_comp_add,ten_rec.tenant_comp_name,ten_rec.tenant_id);
END;

end loop;