Server restrictions
This topic describes the restrictions imposed by different versions of the 9.x and later HCL OneDB™ server. It also describes enhancements made to the JDBC driver and the restrictions imposed by it.
- Only a function can have an OUT parameter. A function is defined as a UDR that returns a value. A procedure is defined as a UDR that does not return a value.
- There can be only one OUT parameter per function.
- The OUT parameter has to be the last parameter.
- You cannot specify INOUT parameters.
HCL OneDB, Version 10.0, or later allows you to specify INOUT parameters (C, SPL, or Java™ UDRs).
- The server does not correctly return the value
NULL
for external functions. - You cannot specify OUT parameters that are complex types.
- You cannot specify C and SPL routines that use the RETURN WITH RESUME syntax.
These restrictions, for server versions 9.2x and 9.3x, are imposed whether users create C, SPL, or Java UDRs.
- Any parameters to be OUT parameters for C, SPL, or Java UDRs
- User-defined procedures with no return value to have OUT parameters
- Multiple OUT parameters
You cannot specify INOUT parameters.
For more information about UDRs, see HCL OneDB User-Defined Routines and Data Types Developer's Guide and HCL® J/Foundation Developer's Guide.