支持存储过程out返回值

最近更新时间: 2024-06-12 15:06:00

postgres=# create or replace procedure triple(x out number) is
begin
    x:=10;
end ;
/
CREATE PROCEDURE
postgres=# declare                                            
  test number:=1;
begin     
  triple(test);
  raise notice 'test = %',test;
end;
/
NOTICE:  test = 10
DO
postgres=#
postgres=# call triple(1);
 x  
----
 10
(1 row)