求助! 存储过程编释出错
ndb96 2003-08-07 12:06:20 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
怎么回事啊????