create or replace procedure PROC_HR_ISNEWUSER(inhandphone in VARCHAR2,
customercode out VARCHAR2,customername out VARCHAR2) is
begin
declare customercode VARCHAR2(100);
begin
customercode :=customercode;
select customercode,customername into customercode,customername
from t_mc_customer
where 1=1 ||customercode || inhandphone;
return;
end PROC_HR_ISNEWUSER;再通过几天的学习,又有进步了```请问上面什么地方写错了`~!
customercode out VARCHAR2,customername out VARCHAR2) is
begin
declare customercode VARCHAR2(100);
begin
customercode :=customercode;
select customercode,customername into customercode,customername
from t_mc_customer
where 1=1 ||customercode || inhandphone;
return;
end PROC_HR_ISNEWUSER;再通过几天的学习,又有进步了```请问上面什么地方写错了`~!
customercode out VARCHAR2,customername out VARCHAR2) is
begin
customercode VARCHAR2(100);
begin
customercode :=customercode;
select customercode,customername into customercode,customername
from t_mc_customer
where 1=1 ||customercode || inhandphone;
return;
end PROC_HR_ISNEWUSER;
定义部分不需要些declare的