PL/SQL:ORA-01747:invalid user.table.column, table.column,or column specificat-
点击右边红色标题查看本文完整版：PL/SQL:ORA-01747:invalid user.table.column, table.column,or column specificat-存储过程报错

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