To specify a stored procedure in an alias, enter the stored procedure as follows:

If the stored procedure is not in a package, you do not have to specify the schema and the package.

To specify the relations for a child alias that issues a stored procedure, you can enter the stored procedure inputs as the parent alias's output values (if applicable), or you can enter the stored procedure inputs as constant values. Specify the inputs, separated by commas, in the order that the stored procedure requires them. You can also specify constant values as input parameters in a relation. Type parent columns in uppercase.

For example, specify the alias's relations as follows:

The results of the stored procedure will be stored in the parent alias' result record. The outputs will be given the names of the stored procedures output parameters.