定义了一个过程 都是报错
1 PLS-00103:Encountered the symbol "IN" when expecting one of the following: :=.),@%default character
不知道是什么,请教是哪错了
下面是代码
create or replace procedure broad01(p_name varchar2 in,p_age varchar2 in,p_mess varchar2 out) as
v_name varchar2(20);
v_age varchar2(20)
begin
v_name:=p_name;
v_age:=v_age;
if v_age != '27' then
p_mess := v_name||v_age
else
p_mess :=v_name||v_age|'error';
end if;
end broad01;
1 PLS-00103:Encountered the symbol "IN" when expecting one of the following: :=.),@%default character
不知道是什么,请教是哪错了
下面是代码
create or replace procedure broad01(p_name varchar2 in,p_age varchar2 in,p_mess varchar2 out) as
v_name varchar2(20);
v_age varchar2(20)
begin
v_name:=p_name;
v_age:=v_age;
if v_age != '27' then
p_mess := v_name||v_age
else
p_mess :=v_name||v_age|'error';
end if;
end broad01;
v_name varchar2(20);
v_age varchar2(20) ;
begin
v_name:=p_name;
v_age:=p_age;
if v_age != '27' then
p_mess := v_name||v_age
else
p_mess :=v_name||v_age|'error';
end if;
end broad01;