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.
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.
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.
Literal Component Name | Component Name Used | Example |
---|---|---|
— | UnifaceParameterName | PARAM1
|
Specified | LiteralParameterName | Param1
|