Hi CREATE OR REPLACE PROCEDURE public.proc(a integer, INOUT b integer, c integer) LANGUAGE plpgsql AS $procedure$ begin b := a + c; end; $procedure$
CREATE OR REPLACE PROCEDURE public.testproc() LANGUAGE plpgsql AS $procedure$ declare r int; begin call proc(10, r, 20); end; $procedure$ postgres=# call testproc(); CALL postgres=# call testproc(); ERROR: SPI_execute_plan_with_paramlist failed executing query "CALL proc(10, r, 20)": SPI_ERROR_ARGUMENT CONTEXT: PL/pgSQL function testproc() line 4 at CALL postgres=# second call fails Regards Pavel