Обсуждение: Function is giving execution error from inside the procedure
Hi,
I am trying to create a simple procedure to updata a table.
CREATE OR REPLACE PROCEDURE bronxdev.pr_asn_wafer_id_update(
)
LANGUAGE 'plpgsql'
AS $BODY$
DECLARE
begin
UPDATE BRONXDEV.ASN_MANUFACTURER_PROFILE
SET WAFER_ID = BRIM(SERIAL_ID, '/')
;
commit;
--rollback;
END
$BODY$;
It is getting compiled without any issue but when I am trying to execute, I am getting BRIM function does not exist error message.
I have tried to google and few other resources and did not help.
Error: ERROR: function brim(character varying, unknown) does not exist LINE 2: SET WAFER_ID = BRIM(SERIAL_ID, '/')
The same UPDATE is directly working from the pgadmin.
I have tried to change LANGUAGE from plpgsql to SQL and that did not help.
My postgres version is 13.2.
Thanks,
Sarwar
Error: ERROR: function brim(character varying, unknown) does not exist LINE 2: SET WAFER_ID = BRIM(SERIAL_ID, '/')
Sent: Friday, February 2, 2024 10:30 AM
To: M Sarwar <sarwarmd02@outlook.com>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: Function is giving execution error from inside the procedure
Error: ERROR: function brim(character varying, unknown) does not exist LINE 2: SET WAFER_ID = BRIM(SERIAL_ID, '/')