On 2/26/24 04:26, Sasmit Utkarsh wrote:
Hi Postgresql Team,
***Facing the below issue, while calling the below procedures in public
and non-public schema *shc* for ( *shc_uadmin* user)
*<3>0164503{00000000-0000-0000-0000-000000000000.noterm}-[ERROR] PREPARE
failed for RIAT! ERROR: procedure sql_select_size_procedure(text,
integer, unknown) does not exist
LINE 1: CALL SQL_select_size_procedure($1, $2, NULL)
^
HINT: No procedure matches the given name and argument types. You might
need to add explicit type casts.*
[../tpfasm.c:13961:SQL_init_db_connection]
<7>0164503{00000000-0000-0000-0000-000000000000.noterm}-ROLLBACK TRANSACTION
1) From the error message:
"ERROR: procedure sql_select_size_procedure(text,
integer, unknown) does not exist"
"No procedure matches the given name and argument types"
From the call:
CALL SQL_select_size_procedure($1, $2, NULL)
You might try:
CALL SQL_select_size_procedure($1, $2, NULL::text)
2) Any clue as to where this:
"...failed for RIAT..."
is comimg from?
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
