December 2002
Intermediate to advanced
928 pages
85h 29m
English
There are a number of requirements for calling stored functions in SQL:
All parameters must be IN; no IN OUT or OUT parameters are allowed.
The datatypes of the function’s parameters and RETURN must be compatible with RDBMS datatypes. You cannot have arguments or RETURN types like BOOLEAN, programmer-defined record, associative arrays, and so on.
The parameters passed to the function must use positional notation; named notation is not supported.
The function must be stored in the database, not in a local program.