create or replace procedure pro_tests( ename_in in emp.empno%type, sal_out out emp.sal%type) as ...[declaration] begin ...[procedure body] end pro_test;
create or replace procedure test(v_tab_no in number, v_rept_time in varchar2, v_return out number) is begin ........ v_return := 0; exception when others then rollback; v_return := 9; end test;
create or replace procedure pro_tests(
ename_in in emp.empno%type,
sal_out out emp.sal%type)
as
...[declaration]
begin
...[procedure body]
end pro_test;
oracle过程
v_rept_time in varchar2,
v_return out number) is
begin
........
v_return := 0;
exception
when others then
rollback;
v_return := 9;
end test;
create procedure test(res out varchar2)
as
begin
select 'test' into res from dual;
end;