＋设为首页 ＋添加到收藏夹
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
怎么回事啊？？？？
应该没有问题，可能是环境的问题。下面是我测试的结果：
SQL> CREATE OR REPLACE
2 procedure ebSMSProc_WriteErrorMsg( inMobile in varchar,
3 inMsg in varchar,
4 retval out number ) as
5
6 sendcontent varchar2(300);
7 fee varchar2(6);
8 servicecode varchar2(10);
9
10 begin
11 sendcontent := Äã¾Í³É¹¦Ò»´Î°É;
12 fee :=000000;
13 servicecode :=0123456789;
14 dbms_output.put_line(sendcontent||fee||servicecode);
15 end;
16 /
Procedure created
