create or replace procedure ceshi as v_sql varchar2(2000); begin v_sql:='comment on table PRO is ''记录表'''; execute immediate v_sql; dbms_output.put_line('测试用例'); end;

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;