title: Why i get Erreur(196,24): PLS-00306: wrong number or types of arguments in call to 'C_MOTIFS'
body: <p>i created a cursor  C_MOTIFS and get Erreur(196,24): PLS-00306: wrong number or types of arguments in call to 'C_MOTIFS'</p>
  <pre><code>Cursor C_MOTIFS(num_doss varchar2 ) Is
                      
                 SELECT
                      f.protocol_nr,
                 CASE
                     WHEN folder_state IN ('09', '10','37','16','07')
                     THEN
                         codes.justification_code
                   
                 END AS code_motif,
                 
                 CASE
                     WHEN folder_state IN ('09', '10','37','16','07')
                     THEN
                         code.justification_code_descr    
                 END AS descr_motif
                 
            FROM his_folder f
                 
           WHERE  f.FOLDER_TYPE_CODE ='10' and f.protocol_nr=num_doss;
  </code></pre>
  <pre><code>FOR SM IN C_MOTIFS
                      LOOP
                          ret_motifs.extend;
                          ret_motifs(nb_motifs):= MOTIF(
                                              SM.code_motif,
                                              SM.descr_motif
                                              );
                          nb_motifs := nb_motifs +1;
                      END LOOP;
  </code></pre>