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: ..."
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]
