← Tutti gli articoli

PlSql Cursor with Parameters

25 settembre 2012  · PLSQL · Recipe  ·  187 visite

Declaring, Fetching, Closing explicit cursors.

declare
    CURSOR importvalidation_cur (pp_import_file_id number) IS
    SELECT 
    import_riga_societa_id,import_file_id,idsocieta,progressivoinvio, iddelega, cfpicliente
    from vw_import_righe_societa1
    WHERE import_file_id=pp_import_file_id

    ;
    
    riga1_rec  importvalidation_cur%ROWTYPE;
              
              
 
        BEGIN
 
          --p_import_file_id  := 6939;
 
          OPEN importvalidation_cur(6939);
 
          Loop
 
             --FETCH riga1_cur INTO riga1_rec; -- p_import_riga_societa_id,p_import_file_id,p_idsocieta,p_progressivoinvio,  p_iddelega, p_cfpicliente;
                FETCH importvalidation_cur INTO riga1_rec;
        
                EXIT WHEN importvalidation_cur%NOTFOUND;
            
 
                dbms_output.put_line('id=' || riga1_rec.import_riga_societa_id);
 
           
 
          End Loop;
 
         CLOSE importvalidation_cur;
 

END;