Adrian Klaver writes:
> On 2/26/24 04:26, Sasmit Utkarsh wrote:
>> ***Facing the below issue, while calling the below procedures in public
>> and non-public schema *shc* for ( *shc_uadmin* user)
> 1) From the error message:
> "ERROR: procedure sql_select_size_procedure(text,
> integer, unknown
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{----.noterm}-[ERROR] PREPARE
failed for RIAT! ERROR: procedu
Hello Boris,
Please find the below snippets for sql_select_size_procedure
/** creation **/
res = PQexec(conn," CREATE OR REPLACE PROCEDURE
*sql_select_size_procedure*(hexid text, rtp_in integer, INOUT size_data text
) LANGUAGE plpgsql AS $$ BEGIN SELECT size FROM riat WHER
Hi Postgresql Team,
***Facing the below issue, while calling the below procedures in public and
non-public schema *shc* for ( *shc_uadmin* user)
[shc_user@cucmtpccu1 ~]$ export PGHOST=
cucmpsgsu0.postgres.database.azure.com
[shc_user@cucmtpccu1 ~]$ export PGDATABASE=mshcd
[shc_user@cucmtpccu1 ~]$
