← 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;