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 |