1、无返回值的存储过程
create or replace procedure test_proc is begin insert into student values('003','mark',27,'s2012090503','15000778382'); commit; end test_proc;
2、有单个数据值返回的存储过程
create or replace procedure test_proc_return(temp_name in varchar2,temp_age out number) is age_1 number; begin select AGE into age_1 from STUDENT where student_name = temp_name; temp_age:=age_1 -5; end;