求助! 存储过程编释出错
CREATE OR REPLACE
procedure ebSMSProc_WriteErrorMsg( inMobile in varchar,
inMsg in varchar,
retval out number ) as
sendcontent varchar2(300);
fee varchar2(6);
servicecode varchar2(10);
begin
sendcontent := '你就成功一次吧';
fee :='000000';
servicecode :='0123456789';
insert into sendcontent_buffer(send_id,sendmobile,acceptmobile,spnumber,service_id,send_content,total_fee,pri,Add_time)
values(send_msg.nextval,'',inMobile,56789,servicecode,sendcontent,fee,1,to_char(sysdate,'yyyymmddhhmiss'));
commit;
end;
/
错误:
sendcontent := '你就成功一次吧';
*
ERROR 位于第 2 行:
ORA-06550: line 2, column 2:
PLS-00201: identifier 'SENDCONTENT' must be declared
ORA-06550: line 2, column 2:
PL/SQL: Statement ignored
ORA-06550: line 3, column 2:
PLS-00201: identifier 'FE' must be declared
ORA-06550: line 3, column 2:
PL/SQL: Statement ignored
ORA-06550: line 4, column 2:
PLS-00201: identifier 'SERVICECODE' must be declared
ORA-06550: line 4, column 2:
PL/SQL: Statement ignored
ORA-06550: line 7, column 10:
PLS-00201: identifier 'SEND_MSG.NEXTVAL' must be declared
ORA-06550: line 6, column 2:
PL/SQL: SQL Statement ignored
怎么回事啊????
procedure ebSMSProc_WriteErrorMsg( inMobile in varchar,
inMsg in varchar,
retval out number ) as
sendcontent varchar2(300);
fee varchar2(6);
servicecode varchar2(10);
begin
sendcontent := '你就成功一次吧';
fee :='000000';
servicecode :='0123456789';
insert into sendcontent_buffer(send_id,sendmobile,acceptmobile,spnumber,service_id,send_content,total_fee,pri,Add_time)
values(send_msg.nextval,'',inMobile,56789,servicecode,sendcontent,fee,1,to_char(sysdate,'yyyymmddhhmiss'));
commit;
end;
/
错误:
sendcontent := '你就成功一次吧';
*
ERROR 位于第 2 行:
ORA-06550: line 2, column 2:
PLS-00201: identifier 'SENDCONTENT' must be declared
ORA-06550: line 2, column 2:
PL/SQL: Statement ignored
ORA-06550: line 3, column 2:
PLS-00201: identifier 'FE' must be declared
ORA-06550: line 3, column 2:
PL/SQL: Statement ignored
ORA-06550: line 4, column 2:
PLS-00201: identifier 'SERVICECODE' must be declared
ORA-06550: line 4, column 2:
PL/SQL: Statement ignored
ORA-06550: line 7, column 10:
PLS-00201: identifier 'SEND_MSG.NEXTVAL' must be declared
ORA-06550: line 6, column 2:
PL/SQL: SQL Statement ignored
怎么回事啊????
...全文
相关推荐
人教部编语文六年级下册第4单元12.为人民服务品读释.pdf
人教部编语文六年级下册第4单元12.为人民服务品读释.pdf
HC-SR505人体热释感应模块.doc
:HC-SR505 人体热释感应模块接口图六、原理图HC-SR505 人体热释感应模块的原理图如下所示:HC-SR505 人体热释感应模块原理图七、实物图HC-SR505 人体热释感应模块的实物图如下所示
RE200B 释热电红外
### 一、RE200B释热电红外传感器简介#### 1.1 定义与原理RE200B是一种基于释热电效应(Pyroelectric Effect)的红外传感器。
甲骨金文旧释“競”的部分字当改释为“丽”.pdf
文章进一步引用了《新甲骨文编》和《甲骨文字编》这两部权威著作,它们最初将A、B、C三种形态的字都归类为“競”。
红外热释电程序
红外热释电程序的核心,在于能够准确地探测人体的热辐射变化,从而触发相应的响应动作。本文将详细介绍红外热释电程序的原理、设计要点以及可能包含的功能模块。


