← Tutti gli articoli

PlSql Cursor with Parameters

25 September 2012  ·  PLSQL · Recipe  ·  179 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;

Si è verificato un errore imprevisto. Ricarica

Rejoining the server...

Rejoin failed... trying again in seconds.

Failed to rejoin.
Please retry or reload the page.

The session has been paused by the server.

Failed to resume the session.
Please retry or reload the page.