Types of Parameters:

A Parameters added to the parameter list can be used to pass a single value to the called form. Instead, parameters can be used to pass a record group or a set of records to the called form. A parameter type determines whether the parameter can contain a single value or can contain a record group. A Parameters type can be any one of the given below:

• TEXT_PARAEMTER
• DATA_PARAMETER

Text Parameter:

Whenever a single value is passed as a parameter to the called form, the parameter type must be set to 'TEXT_PARAMETER'.

Example:

Whenever client_no 'C00001' is passed as a parameter form the client form to the order form the Parameter Type, set for a parameter will be 'TEXT_PARAMETER'.

Data Parameter:

When a record group is being passed as a parameter, the parameter type must be set to 'DATA_PARAMETER'

Example:

Create a parameter list which is named by client_list and assign the memory address of the parameter list to a memory variable known as client_param_list. Add a parameter named p_client_no and specify its value as 'C00001'. Because one value is being passed as a parameter, the type of parameter should be 'TEXT_PARAMETER'.

DECLARE

client_param_list paramlist;

BEGIN

client_param_list := create_parameter_list

('client_list');

add_parameter (client_param_list, 'p_client_no', text_parameter, 'C00001');# add a parameter in client_list#

END;