17,377
社区成员
发帖
与我相关
我的任务
分享
create procedure test(res out varchar2)
as
begin
select 'test' into res from dual;
end;
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;