是不是这个 好像少个字段create or replace procedure addY_brush(pBrush in Date,pBrushtype in Varchar2,pMachineno in Number Default := '',pStype in Number Default :='',
pDowntime in Date,pManipulator in Varchar2,Partition in Number)
as
declare
i NUMBER(1) default :=0;
begin
insert into Y_Brush (ckey.nextnal,personkey,deptid,
deptname,name,nameEng,
codeNo,BRUSH,BRUSHTYPE,MACHINENO,
STYLE,DOWNTIME,MANIPULATOR)
select Personkey,Deptid,DeptName,Name,NameEng,
IDCodeNo,pBrush,pBrushtype,pMachineno,
pStype,pDowntime,pManipulator
from temp_personal;end
pDowntime in Date,pManipulator in Varchar2,Partition in Number)
as
declare
i NUMBER(1) default :=0;
begin
insert into Y_Brush (ckey.nextnal,personkey,deptid,
deptname,name,nameEng,
codeNo,BRUSH,BRUSHTYPE,MACHINENO,
STYLE,DOWNTIME,MANIPULATOR)
select Personkey,Deptid,DeptName,Name,NameEng,
IDCodeNo,pBrush,pBrushtype,pMachineno,
pStype,pDowntime,pManipulator
from temp_personal;end
数字型怎么赋的字符型啊
没有declare关键字啊
(
pBrush in Date,
pBrushtype in Varchar2,
pMachineno in Number Default 0 ,
pStype in Number Default 0,
pDowntime in Date,
pManipulator in Varchar2,
Partition in Number
)
as
i NUMBER(1) default 0;
begin
for i in 0..Partition
loop
insert into Y_Brush(
ckey.nextnal ,
personkey ,
deptid ,
deptname ,
name ,
nameEng ,
codeNo ,
BRUSH ,
BRUSHTYPE ,
MACHINENO ,
STYLE ,
DOWNTIME ,
MANIPULATOR )
select i ,
Personkey ,
Deptid ,
DeptName ,
Name ,
NameEng ,
IDCodeNo ,
pBrush ,
pBrushtype ,
pMachineno ,
pStype ,
pDowntime ,
pManipulator
from temp_personal;
--建議再這兒加條件
i:=i+1; end loop;
end;