Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
vl_requete := 'SELECT '||vl_columns||' FROM '||vl_CODE_VUE_GENERE_REJ;
dbms_output.put_line('vl_requete:'||vl_requete);
 
 
FOR rec IN  ('SELECT '||vl_columns||' FROM '||vl_CODE_VUE_GENERE_REJ ) LOOP 
  r := r+1 ;
  write_cell_char( r,1, 'sheet1' , rec.nom, 'sgs2'  );
  write_cell_char( r,2, 'sheet1' , rec.prenom, 'sgs2' );
 
END LOOP ;

Error at line 1
ORA-06550: line 88, column 13:
PLS-00103: Encountered the symbol "LOOP" when expecting one of the following: