create or replace procedure test1 as
cursor Cur_TB_REQUETE is select * from TB_REQUETE ;

compte number;
begin

for Cur in Cur_TB_REQUETE loop
execute  immediate Cur.Sql_Requete into compte;

insert into TB_RESULT (num_req,date_result,result_req )  
values(Cur.Num,sysdate,compte);
commit;

end loop;

end test1;