On Tue, Oct 8, 2019 at 11:56 AM Pepe TD Vo <pepevo(at)yahoo(dot)com> wrote:
> ERROR: invalid input syntax for integer: "42P01" CONTEXT: PL/pgSQL
> function ecisdrdm.pr_mig_stg_application_cdim() line 41 at assignment SQL
> state: 22P02
>
You made an assumption that the error code was an integer. As the error
message is pointing out one possible value of the error code is "42P01"
which is not an integer. You need to fix your code to match reality - that
the error code is an alphanumic.
may I know how to execute the stored function?
>
The fact that the function provoked an error means that it was executed.....
David J.