创建存储过程时报错:
PLS-00410: duplicate fields in RECORD,TABLE or argument list are not permitted
PL/SQL: Compilation unit analysis terminated
后来发现输出参数和定义的变量重复了!
create or replace procedure proc(
name in varchar2,
rec out sys_refcursor)
as
ename varchar2(100);
job varchar2(100);
begin
...
end;
上面就name in varchar2,与name varchar2(100)重复定义了~