Parameter Types Used With Service Stored Procedures

Service stored procedures (SSPs) support Uniface scalar data types and entity parameters. Occurrence parameters are not supported.

The following parameters are used with SSPs:

  • Scalar parameters—include all scalar data types except image and raw for IN, OUT, and INOUT parameters. For more information, see Uniface Data Types.

    The raw data type is supported as a parameter for service stored procedures on Sybase.

  • Entity parameters —used to return result sets from a stored procedure. For some databases, entity parameters are not associated with an explicit stored procedure parameter. In this case, entity parameters are mapped to DBMS result sets, which consist of sets of entity fields.

    Entity parameters can only be used for output. They can be mixed with scalar parameters.

The data types of component operation parameters must correspond to, or must be implicitly convertible to, stored procedure parameters. Some databases are more flexible than others in their support for explicit/implicit data conversion.