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
