ORACLE 游标,过程练习

CREATE OR REPLACE PROCEDURE EMP_VIEW_PS
(emp_no in emp.deptno%type)
--定义存储过程形参

AS
STR varchar2(500);
CURSOR MYNAME(myno emp.deptno%type) IS SELECT * FROM EMP where deptno = myno;
--定义游标形参

BEGIN
       -- STR := 'set serveroutput on';

       --在SQL语句中调用上面的命令会出错?

       --STR := 'SELECT * FROM EMP';

       --这上面的却不会?

       --execute immediate STR;

       FOR MYACT IN MYNAME(emp_no)
       --给游标传参

       --MYACT不用事先定义

       LOOP
           dbms_output.put_line(MYACT.ENAME);
       END LOOP;
END EMP_VIEW_PS;