请帮我看下这个存储过程错在哪，谢谢。系统总是提示compiled but with compilation errors

create or replace procedure pro_name
(spcode in number,
sppasswd in varchar2
)
is
v_name varchar2;
begin
select name into v_name from stu2 where stu1.code=spcode;
select name into v_name from stu2 where stu1.passwd=sppasswd;

dbms_output.put_line('用户名:'||v_name|| );
end;

create or replace procedure pro_name
(spcode in number,
sppasswd in varchar2
)
is
v_name varchar2(3000);
begin
select name into v_name from stu2 where stu1.code=spcode;
select name into v_name from stu2 where stu1.passwd=sppasswd;

dbms_output.put_line('用户名:'||v_name);
end;
系统提示Warning: compiled but with compilation errors。求高手帮忙指导下，我是在Toad For oracle 中编译的。

create or replace procedure pro_name
(spcode in number,
sppasswd in varchar2
)
is
v_name varchar2 :='abc';
begin
--select name into v_name from stu2 where stu1.code=spcode;
--select name into v_name from stu2 where stu1.passwd=sppasswd;

dbms_output.put_line('用户名:'||v_name|| );
end;
--以下语句错误，可以换成其他语句看看
--select name into v_name from stu2 where stu1.code=spcode;
--select name into v_name from stu2 where stu1.passwd=sppasswd;

dbms_output.put_line('用户名:' ||v_name||); || 是连接符，用来连接字符串，上面的括号里v_name后有个多余的|| ,下面的应该救正确了 dbms_output.put_line('用户名:' ||v_name);

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息