首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > oracle >

PL/SQL:ORA-01747:invalid user.table.column, table.column,or column specificat-存储

2014-01-28 
create or replace PROCEDURE TAOCAN_OPERATOR AStemp_count NUMBER(10)beginfor mdc in (select phone

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         

热点排行