Informix Error -9710: Overloading of built-in functions is not allowed.

Cause and resolution

Overloading of built-in functions is not allowed.

Built-in functions such as dbinfo and trim should not be overloaded. Change the name of the routine that you are creating so that it does not conflict with the names already used in the database server.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-9710 fires when a CREATE FUNCTION/PROCEDURE statement reuses the name of a built-in function — per the official guidance.

The new routine's name colliding with a built-in function, per the official guidance — the direct, only cause; built-in functions such as dbinfo and trim can't be overloaded.

Solutions / Resolution

Change the name of the routine being created so it doesn't conflict with names already used in the database server, per the official guidance.

Examples

Overloading a built-in function

CREATE FUNCTION trim(a LVARCHAR) RETURNING LVARCHAR ...;   -- -9710

Corrected

CREATE FUNCTION my_trim(a LVARCHAR) RETURNING LVARCHAR ...;

Diagnostic Checks

Check whether the new routine's name matches a built-in function, and rename it if so.

Related Errors / Related Topics

-9719 — "A routine and an aggregate cannot share the same name." A related name-collision restriction, against aggregate names (including built-in aggregates) rather than built-in functions.

A routine's name collided with a built-in function — rename the routine.