create or replace procedure P_getStuName(v_stuID in number) is
x varchar2(80);
begin
select stuName into x from daTest where stuID = v_stuID;
dbms_output.put_line(s);
end P_getStuName;
x varchar2(80);
begin
select stuName into x from daTest where stuID = v_stuID;
dbms_output.put_line(s);
end P_getStuName;
RETURN INTEGER
is
x varchar2(80);
begin
select stuName into x from daTest where stuID = v_stuID;
RETURN stuName;
end P_getStuName;