CREATE OR REPLACE PROCEDURE ProcUserAttendance
(Year in NUMBER,
Month in NUMBER)
IS
begin
Delete From GateCard Where GCYear=iYear AND GCMonth=iMonth;
INSERT INTO GateCard (Userid,,GCYEAR,GCMONTH)
Values
(
(Select UserID, From tbUser
Where UserState=0
),
iYear,iMonth
);
end;运行后报错如下:
ORA-06550: 第 2 行, 第 7 列:
PLS-00905: 对象 HUARUI2016.PROCUSERATTENDANCE 无效
ORA-06550: 第 2 行, 第 7 列:
PL/SQL: Statement ignored
(Year in NUMBER,
Month in NUMBER)
IS
begin
Delete From GateCard Where GCYear=iYear AND GCMonth=iMonth;
INSERT INTO GateCard (Userid,,GCYEAR,GCMONTH)
Values
(
(Select UserID, From tbUser
Where UserState=0
),
iYear,iMonth
);
end;运行后报错如下:
ORA-06550: 第 2 行, 第 7 列:
PLS-00905: 对象 HUARUI2016.PROCUSERATTENDANCE 无效
ORA-06550: 第 2 行, 第 7 列:
PL/SQL: Statement ignored
Userid ,后面写了两个逗号。
Select UserID, iYear,iMonth From tbUser Where UserState=0;