求助! 存储过程编释出错

ndb96 ndb96 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
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

怎么回事啊????

...全文

相关推荐

评论 4
收藏 已收藏
分享
返回顶部
ndb96
Oracle 17,133 成员 55,258 内容