Naming Specifications for Service Store Procedures

For Service Stored Procedures, the signature of the Stored Procedure Component maps the names of Uniface components, operations, and parameters to the name of a package, procedure, and parameter names in the procedure.

Names of Uniface components, operations, and parameters are always in uppercase, but the names of stored procedures may be lowercase and case-sensitive. Furthermore, you may want to qualify the name of a stored procedure, for example, by specifying the schema or package in which the procedure is defined.

In the Signature Editor, you can define a literal name for each component, operation, and/or parameter, thereby mapping the Uniface names to the procedure names. The actual names Uniface uses to activate service stored procedures depends on this mapping.

The following tables describe the effect that the literal name has on the actual name used.

Note: Component, operation, and parameter names are the default name used by Uniface; always uppercase. Literal names are package or schema names and are case-sensitive.

Component Names

A component name can be used to qualify operation names. For some databases, the component name can refer to a package. For others, it refers to a schema.

Component Name Specification
Literal Component Name Component Name Used Example
UnifaceComponentName

DBSSP

Specified LiteralComponentName

sp

Operation Names

The component operation name is mapped to a stored procedure name, so the operation name must resemble the stored procedure name.

Operation Name Specification
Literal Component Name Component Name Used Example
UnifaceOperationName SP1
Specified LiteralOperationName sp1

Parameter Names

The number and order of the operation parameters must match those within the stored procedure.

The operation parameter name is mapped to a formal parameter name within the stored procedure, so all operation parameter names must resemble the stored procedure parameter names.

Parameter name specification
Literal Component Name Component Name Used Example
UnifaceParameterName PARAM1
Specified LiteralParameterName Param1