存储过程(入门级)

--存储过程--

------------

--定义 creat [or replace] procedure pro_name(arg1 in type1 ,arg2 out type2) is [临时变量1,临时变量2]

--练习

create or replace procedure proc_jacky_class
(
emp_innum in class.id%type,
emp_name out class.name%type
)
as
begin
select name into emp_name from class where id = emp_innum;
end proc_jacky_class;

--成功;

--测试语句

declare
   arg1 class.id%type := 8;
   arg2 class.name%type;
begin

proc_jacky_class(arg1,arg2);
dbms_output.put_line(arg2);

end;
---依然成功