( VMOBIL IN VARCHAR2, VMESSAGE IN VARCHAR2, VINCEPTID IN VARCHAR2, VSENDERID IN VARCHAR2 ) as begin INSERT INTO "MOP"."SMSEND"(NID,MOBILE,MESSAGE,FLAG,CREATIME,INCEPTID,SENDERID,FLAG1) VALUES(MOP.seq_smsend.NEXTVAL,VMOBIL,VMESSAGE,'0',SYSDATE,VINCEPTID,VSENDERID,'0'); commit; exception when others then rollback; end;行号= 9 列号= 20 错误文本= PL/SQL: ORA-00942: table or view does not exist 行号= 9 列号= 2 错误文本= PL/SQL: SQL Statement ignored
VMOBIL IN VARCHAR2,
VMESSAGE IN VARCHAR2,
VINCEPTID IN VARCHAR2,
VSENDERID IN VARCHAR2
)
as
begin
INSERT INTO "MOP"."SMSEND"(NID,MOBILE,MESSAGE,FLAG,CREATIME,INCEPTID,SENDERID,FLAG1)
VALUES(MOP.seq_smsend.NEXTVAL,VMOBIL,VMESSAGE,'0',SYSDATE,VINCEPTID,VSENDERID,'0');
commit;
exception
when others then
rollback;
end;行号= 9 列号= 20 错误文本= PL/SQL: ORA-00942: table or view does not exist
行号= 9 列号= 2 错误文本= PL/SQL: SQL Statement ignored