PostgreSQL has a limit on the number of procedure/function parameters = 100, which is set by the preset configuration parameter max_function_args.

We do not recommend changing the value of this parameter as it may cause errors on the server.

Instead, our tool creates an additional user-defined type that contains all the IN parameters of the procedure, and the parameter of this type will be used as the procedure only parameter:

  CREATE TYPE proc_empl1_PS as(pt1 VARCHAR(40), pt2 VARCHAR(35), p1 INTEGER, p2 INTEGER, p3 INTEGER, p4 INTEGER, p5 INTEGER,
      p6 INTEGER, p7 INTEGER, p8 INTEGER, p9 INTEGER, p10 INTEGER, p11 INTEGER, p12 INTEGER, p13 INTEGER, p14 INTEGER, p15 INTEGER,
      p16 INTEGER, p17 INTEGER, p18 INTEGER, p19 INTEGER, p20 INTEGER, p21 INTEGER, p22 INTEGER, p23 INTEGER, p24 INTEGER, p25 INTEGER, 
      p26 INTEGER, p27 INTEGER, p28 INTEGER, p29 INTEGER, p30 INTEGER, p31 INTEGER, p32 INTEGER, p33 INTEGER, p34 INTEGER, p35 INTEGER, 
      p36 INTEGER, p37 INTEGER, p38 INTEGER, p39 INTEGER, p40 INTEGER, p41 INTEGER, p42 INTEGER, p43 INTEGER, p44 INTEGER, p45 INTEGER, 
      p46 INTEGER, p47 INTEGER, p48 INTEGER, p49 INTEGER, p50 INTEGER, p51 INTEGER, p52 INTEGER, p53 INTEGER, p54 INTEGER, p55 INTEGER,
      p56 INTEGER, p57 INTEGER, p58 INTEGER, p59 INTEGER, p60 INTEGER, p61 INTEGER, p62 INTEGER, p63 INTEGER, p64 INTEGER, p65 INTEGER,
      p66 INTEGER, p67 INTEGER, p68 INTEGER, p69 INTEGER, p70 INTEGER, p71 INTEGER, p72 INTEGER, p73 INTEGER, p74 INTEGER, p75 INTEGER,
      p76 INTEGER, p77 INTEGER, p78 INTEGER, p79 INTEGER, p80 INTEGER, p81 INTEGER, p82 INTEGER, p83 INTEGER, p84 INTEGER, p85 INTEGER,
      p86 INTEGER, p87 INTEGER, p88 INTEGER, p89 INTEGER, p90 INTEGER, p91 INTEGER, p92 INTEGER, p93 INTEGER, p94 INTEGER, p95 INTEGER,
      p96 INTEGER, p97 INTEGER, p98 INTEGER, p99 INTEGER, p100 INTEGER, p101 INTEGER, p102 INTEGER);

  CREATE OR replace PROCEDURE proc_empl1(SWP_INPUT proc_empl1_PS)
  LANGUAGE plpgsql
     AS $$
  BEGIN
  -- This procedure was converted on Thu Mar 09 15:25:25 2023 using Ispirer SQLWays 10.0 Build 7390 Revision 0 64bit Licensed to Ispirer - 
  Ispirer Toolkit 10 All to All Data Migration Standard Project License (26 Months, 20241119).
     SWP_INPUT.p1 := SWP_INPUT.p2;
  END; $$;

If you have any other questions regarding the usage of our tool, please contact our support team at support@ispirer.com