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@aklaver.com