DECLARE
d_no dept.deptno%TYPE;
d_name yhh_dept.dname%TYPE;
d_loc yhh_dept.loc%TYPE;
CURSOR c(dept_no Number default 10 ) IS
SELECT * FROM dept Where deptno <=dept_no;
BEGIN
OPEN c (d_no>=3);
LOOP
FETCH c INTO deptrec,dept_name, dept_loc;
EXIT WHEN c%NOTFOUND;
DBMS_OUTPUT.PUT_LINE(d_no||'#########'||d_name||'---'||d_loc);
END LOOP;
CLOSE c3;
END;
OPEN C ( d_no>=3)
这个地方传参时老报错, 为什么?怎么解决? 谢谢!!!!