Description
Submitted by: Oleg Matveyev (o_matveev)
1. Correct command with no error messages:
DECLARE EXTERNAL FUNCTION udfTest15
INTEGER, -- 1
INTEGER, -- 2
INTEGER, -- 3
INTEGER, -- 4
INTEGER, -- 5
INTEGER, -- 6
INTEGER, -- 7
INTEGER, -- 8
INTEGER, -- 9
INTEGER, -- 10
INTEGER, -- 11
INTEGER, -- 12
INTEGER, -- 13
INTEGER, -- 14
INTEGER -- 15
RETURNS INTEGER BY VALUE
ENTRY_POINT 'udf' MODULE_NAME 'fbudf';
2. Command with error
Dynamic SQL Error.
SQL error code = -607.
Invalid command.
External functions cannot have more than 10 parameters.
DECLARE EXTERNAL FUNCTION udfTest16
INTEGER, -- 1
INTEGER, -- 2
INTEGER, -- 3
INTEGER, -- 4
INTEGER, -- 5
INTEGER, -- 6
INTEGER, -- 7
INTEGER, -- 8
INTEGER, -- 9
INTEGER, -- 10
INTEGER, -- 11
INTEGER, -- 12
INTEGER, -- 13
INTEGER, -- 14
INTEGER, -- 15
INTEGER -- 16
RETURNS INTEGER BY VALUE
ENTRY_POINT 'udf' MODULE_NAME 'fbudf';