On Linux, creating, replacing, or altering a UDF, UDM, or external stored procedure (collectively called external routines) can produce an "Argument list too long" error.
You get this error if the database in which you want to create, replace, or alter the external routine has a large number of external routines or external routines with long names.
The new external routine compiles (or recompiles) successfully, but when the name of the resulting object file is added to the list of object files for all of the external routines already in the database, the compiler cannot create a new dynamic linked library (.so file) because the resulting list exceeds the maximum command line argument size.
To work around this limitation on Linux, you can do any of the following:
- Drop all unnecessary UDTs and external routines from the database.
- Instead of installing each external routine individually, create a package or library of external routines and install the package.