as 后要写begin CREATE OR REPLACE PROCEDURE Bomcopy(Oldid VARCHAR2, Newid VARCHAR2, USER VARCHAR2, Company VARCHAR2) AS begin INSERT Cc_Record_Bom SELECT Sys_Guid(), Item, Item_Class, Item_d, Item_d_Class, Net_Qty, Waste_Qty, Total_Qty, Bom_Ver, Start_Date, End_Date, Newid, Remark, USER, SYSDATE, USER, SYSDATE, Company FROM Cc_Record_Bom WHERE Code = Oldid; INSERT Cc_Stand_Bom SELECT Sys_Guid(), Item, Item_d, Net_Qty, Waste_Qty, Total_Qty, Bom_Ver, Start_Date, End_Date, Newid, Remark, USER, SYSDATE, USER, SYSDATE, Company, Item_Class, Item_d_Class FROM Cc_Stand_Bom WHERE Code = Oldid; INSERT Cc_Wo_Bom SELECT Item, Item_d, Net_Qty, Waste_Qty, Total_Qty, Bom_Ver, Start_Date, End_Date, Newid, Remark, USER, SYSDATE, USER, SYSDATE, Company, Item_Class, Item_d_Class FROM Cc_Wo_Bom WHERE Code = Oldid; END Bomcopy;

我刚刚遇到这个问题。是这样的，排除你采纳的那个答案的话，还有可能是半角全角空格的问题。若你的程序是从网上当下来修改的话，就可能有这个问题，把代码删掉重新自己手打一下就好了。