Hi Adrian Thanks for the input
On Sun, Oct 25, 2026 at 2:42 PM Adrian Klaver <[email protected]> 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: ..." > > In the second case with 3 parameters: SELECT getSessDbKey (iSessionId => '1234'::text, iUser => .... This was called from the psql command line, the OUT values were returned in the terminal, example: getsessdbkey --------------- (3,,keyFound) Thanks for the link, for the 1st case I had defined the IN and OUT parameters in the parent function, I have also just tried the: parameterName ALIAS FOR $x , but that did not make a difference Mark Edit I have just seen your follow up message, there are no INOUT parameters > > > > I just tried to user CALL and the HINT was to use SELECT > > > > Mark > > > > On Sun, Oct 25, 2026 at 1:00 PM Tom Lane <[email protected] > > <mailto:[email protected]>> wrote: > > > > Mark <[email protected] <mailto:[email protected]>> writes: > > > I am getting the following error which has been driving me crazy: > > > ERROR: function getsessdbkey(text, text, text, bigint, > > customType, text) > > > does not exist > > > > (1) search_path problem, perhaps? > > (2) are you using a CALL statement to call it? > > > > regards, tom lane > > > > > -- > Adrian Klaver > [email protected] >
