Question

oracle中创建过程提示带有编译错误 create or replace procedure myproc (cno char , cname out varchar2

create or replace procedure myproc
(cno char , cname out varchar2 ,ctel out varchar ) is
begin
select c_TrueName into cname , c_mobile into ctel
from Customers where c_ID=cno;
end myproce;
/

Answer 1

create or replace procedure myproc
(cno char ,
cname out varchar2 ,
ctel out varchar )
is
begin
select c_TrueName,c_mobile into cname,ctel from Customers where c_ID=cno;
end myproce;