On 10/25/26 7:42 AM, Adrian Klaver wrote:
On 10/25/26 6:26 AM, Mark wrote:
Thanks for the input Tom
1) SHOW search_path; -- produces the following and the function was in
the public schema (and both created by the same user)
search_path
-----------------
"$user", public
2) I was calling it with:
SELECTgetSessDbKey (jSessionId, jUser, 'functionName'::text,
vSessDbKey, vSessRet, vGetSessDbKeyMess);
This is not the same as:
SELECT getSessDbKey (iSessionId => '1234'::text, iUser => 'cmd
test'::text, iFunction => 'cmd test'::text);
Note 3 parameters vs 6 in the 2).
And from here:
https://www.postgresql.org/docs/current/plpgsql-
declarations.html#PLPGSQL-DECLARATION-PARAMETERS
"To call a function with OUT parameters, omit the output parameter(s) in
the function call: ..."
Forgot to add there is INOUT if you want to use the parameters either
way, see:
https://www.postgresql.org/docs/current/sql-createfunction.html
"argmode
The mode of an argument: IN, OUT, INOUT, or VARIADIC. If omitted,
the default is IN. Only OUT arguments can follow a VARIADIC one. Also,
OUT and INOUT arguments cannot be used together with the RETURNS TABLE
notation.
"
--
Adrian Klaver
[email protected]
