Oracle带参数的游标

create or replace procedure 带参数的游标
as
  v_taid number(4);
  v_taname VARCHAR2(100);
  v_bqid number;
CURSOR emp_cur(v_taname VARCHAR2) is --此处参数只是一个占位符而已
 SELECT taid, taname,bqid FROM table3 WHERE taid = v_taid;
begin
    v_taid := 1;
    OPEN emp_cur(v_taname);
    LOOP
      FETCH emp_cur
        INTO v_taid, v_taname,v_bqid;
      EXIT WHEN emp_cur%NOTFOUND;
      DBMS_OUTPUT.PUT_LINE(v_taid|| ' ' || v_taname || ' ' || v_bqid);
    END LOOP;
    CLOSE emp_cur;
 
  end 带参数的游标;

转载于:https://www.cnblogs.com/yuan-2012/archive/2012/06/10/2543741.html