The CREATE OR REPLACE PROCEDURE ProcUserAttendance
(Year in NUMBER,
The Month in NUMBER)
IS
The begin
The Delete From GateCard Where GCYear=iYear AND GCMonth=iMonth;
INSERT INTO GateCard (Userid GCYEAR, GCMONTH)
Values
(
(Select UserID, the From tbUser
Where UserState=0
),
IYear, iMonth
);
end;

After the operation error is as follows:
ORA - 06550: line 2 and 7:
PLS - 00905: object HUARUI2016 PROCUSERATTENDANCE invalid
ORA - 06550: line 2 and 7:
PL/SQL Statement ignored

CodePudding user response:

Don't see the object, you haven't seen this object inside a stored procedure, how to quote the wrong

CodePudding user response:

INSERT INTO GateCard (Userid GCYEAR, GCMONTH)


Userid, behind wrote two commas,

CodePudding user response:

Direct write OK

INSERT INTO GateCard (Userid, GCYEAR GCMONTH)
The Select UserID, iYear, iMonth From tbUser Where UserState=0;