Using parameter markers or the NULL values as function arguments

 

You cannot use a parameter marker or a NULL value as a function argument. Because function resolution does not know what data type this type of argument might turn out to be, it cannot resolve the reference.

You cannot code the following:

     BLOOP(?)

or

     BLOOP(NULL)

You can use the CAST specification to provide a data type for the parameter marker or NULL value that function resolution can use:

     BLOOP(CAST(? AS INTEGER))

or

     BLOOP(CAST(NULL AS INTEGER))

 

Parent topic:

Using UDFs in SQL statements