PLS-00410: duplicate fields in RECORD,TABLE or argument list

SQL> r
  1  create or replace procedure  p_query_dept(v_ename in varchar2,o_rec out sys_refcursor)
  2  as
  3  v_ename emp.ename%type;
  4  v_job   emp.job%type;
  5  v_sal   emp.sal%type;
  6  begin
  7  open o_rec for 'select ename,job,sal from emp where ename like :x' using v_ename;
  8  loop
  9  fetch o_rec into v_ename,v_job,v_sal;
 10  exit when emp_rec%notfound;
 11  dbms_output.put_line(o_rec.v_ename||o_rec.v_job||o_rec.v_sal);
 12  end loop;
 13  close o_rec;
 14* end;
Warning: Procedure created with compilation errors.
SQL> show err
Errors for PROCEDURE P_QUERY_DEPT:
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0      PL/SQL: Compilation unit analysis terminated
1/1      PLS-00410: duplicate fields in RECORD,TABLE or argument list are
         not permitted
SQL>
 
 
小结:
 v_ename emp.ename%type;
同p_query_dept(v_ename in varchar2,o_rec out sys_refcursor)
重复定义了!
请使用浏览器的分享功能分享到微信等