是不是这个 好像少个字段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

解决方案 »

  1.   

    建议先搞清楚insert语句的基本语法。以后提问最好有其他相关信息,比如执行环境,报错信息,表结构等。
      

  2.   

    create or replace procedure addY_brush(pBrush in Date,pBrushtype in Varchar2,pMachineno in Number Default := '',________________在这 类型不匹配
    数字型怎么赋的字符型啊
      没有declare关键字啊
      

  3.   

    create or replace procedure addY_brush
          (
           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;