oracle 错误：PLS-00410：不允许记录、表或参数列表中的重复字段
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/47614582/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Error: PLS-00410: duplicate fields in RECORD,TABLE or argument list are not permitted
提问by john
I am having trouble with is stored procedure. I keep getting this error: Error: PL/SQL: Compilation unit analysis terminated Error: PLS-00410: duplicate fields in RECORD,TABLE or argument list are not permitted
我在使用存储过程时遇到问题。我不断收到此错误：错误：PL/SQL：编译单元分析终止错误：PLS-00410：不允许记录、表或参数列表中的重复字段
This is what i tried to run:
这是我试图运行的：
create or replace procedure service_order_proc
(
SERVICE_ORDER_ID NUMBER,
CUST_ID NUMBER,
EMP_ID NUMBER,
SERVICE_DATE DATE,
SERVICE_ORDER_STATUS_ID NUMBER,
SERVICE_ORDER_TYPE_ID NUMBER,
SERVICE_TOTAL NUMBER,
EMP_ID NUMBER,
FNAME VARCHAR2,
LNAME VARCHAR2,
PNUMBER VARCHAR2,
EMP_STATUS_ID NUMBER,
EMP_GROUP_ID NUMBER
)
AS BEGIN
insert into service_order values (SERVICE_ORDER_ID, CUST_ID, EMP_ID, SERVICE_DATE,
SERVICE_ORDER_STATUS_ID, SERVICE_ORDER_TYPE_ID, SERVICE_TOTAL);
insert into employee values (EMP_ID, FNAME, LNAME, PNUMBER,
EMP_STATUS_ID, EMP_GROUP_ID);
end;
回答by ishando
you have EMP_IDlisted twice as a parameter to the procedure
您已将EMP_ID两次列为该过程的参数
