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 带参数的游标;