存储过程基础

--创建输入参数存储过程
create or replace procedure lyr3(name varchar2,age number) is
begin
insert into student values(sys_guid(),name,age);
end;

--创建输出存储过程
create procedure lyr4(v_name out varchar2) is
begin
select name into v_name from student where age=20;
end;

--调用输出存储过程
--此处要注意块编程的顺序以及结构
--set serveroutput on 打开输出
set serveroutput on
declare
v_name student.name%type;
begin
lyr4(v_name);
dbms_output.put_line(v_name);
end;