Oracle parameter-based cursor

Oracle parameter-based cursor declare cursor mysor (proname varchar2) isselect * from sys_pro_monitor where pro_name = proname; c_row mysor % rowtype; begin open mysor ('Pro _ RPT_KPI '); loop fetch mysor into c_row; exit when mysor % notfound; dbms_output.put_line (c_row.id); end loop; end; Method 2: www.2cto.com declare cursor mysor (proname varchar2) isselect * from sys_pro_monitor where pro_name = proname; c_row mysor % rowtype; begin for c_row in mysor ('Pro _ RPT_KPI ') loop dbms_output.put_line (c_row.id); end loop; end;