日期:2014-05-17  浏览次数:20721 次

关于过程报错
create   or   replace   PROCEDURE "TAOCAN_OPERATOR "
AS
    temp_count   NUMBER(10);
   
begin  
      for   mdc   in   (select   phonecc,tctype   from   taocantest   where   tctype= '6 '   or   tctype= '10 '   or   tctype= '16 ')   loop
          select   count(PHONENUMBER)   into   temp_count   from   SMS_SP_TIANQIYUBAO   where   SMS_SP_TIANQIYUBAO.PHONENUMBER=mdc.phonecc;
              if   temp_count <> 0     then
          update   SMS_SP_TIANQIYUBAO   set   SMS_SP_TIANQIYUBAO.STATUS=3,SMS_SP_TIANQIYUBAO.type=mdc.tctype  
            where   SMS_SP_TIANQIYUBAO.PHONENUMBER=mdc.phonecc;
          else  
                insert   into   SMS_SP_TIANQIYUBAO(seq_SMS_SP_TIANQIYUBAO.nextval,mdc.phonecc, '1111 ', '3 ',sysdate,mdc.tctype, ' ');
          commit;
    end   if;
    end   loop;
    END    

错误如下:
reate   or   replace   PROCEDURE "TAOCAN_OPERATOR "
AS
    temp_count   NUMBER(10)
Warning:   Procedure   created   with   compilation   errors
 
begin
      for   mdc   in   (select   phonecc,tctype   from   taocantest   where   tctype= '6 '   or   tctype=
          select   count(PHONENUMBER)   into   temp_count   from   SMS_SP_TIANQIYUBAO   where   SMS
              if   temp_count <> 0     then
          update   SMS_SP_TIANQIYUBAO   set   SMS_SP_TIANQIYUBAO.STATUS=3,SMS_SP_TIANQIYUBA
            where   SMS_SP_TIANQIYUBAO.PHONENUMBER=mdc.phonecc;
          else
                insert   into   SMS_SP_TIANQIYUBAO(seq_SMS_SP_TIANQIYUBAO.nextval,mdc.phonec
          commit;
    end   if;
    end   loop;
    END
ORA-06550:   line   8,   column   83:
PL/SQL:   ORA-01747:   invalid   user.table.column,   table.column,   or   column   specificat
ORA-06550:   line   8,   column   9:
PL/SQL:   SQL   Statement   ignored
ORA-06550:   line   13,   column   0:
PLS-00103:   Encountered   the   symbol   "end-of-file "   when   expecting   one   of   the   follow

      ;   <an   identifier>   <a   double-quoted   delimited-identifier>
The   symbol   "; "   was   substituted   for   "end-of-file "   to   continue.



------解决方案--------------------
END 后面少了;
------解决方案-------------