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
uj5u.com熱心網友回復：
沒看到這個物件，你的存盤程序里面都沒看到這個物件，怎么會報這個錯的uj5u.com熱心網友回復：
INSERT INTO GateCard (Userid,,GCYEAR,GCMONTH)Userid ，后面寫了兩個逗號。
uj5u.com熱心網友回復：
直接寫就OKINSERT INTO GateCard (Userid,GCYEAR,GCMONTH)
Select UserID, iYear,iMonth From tbUser Where UserState=0;
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/112111.html
標籤：開發