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 后面少了;
------解决方案--------------------
invalid user.table.column, table.column, or column specificat
是否表名，列名错了