1、无返回值的存储过程

create or replace procedure test_procisbegin  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) isage_1 number;begin  select AGE  into age_1  from STUDENT  where student_name = temp_name;  temp_age:=age_1 -5;end;