What are the parameters?

Parameters provide a simple mechanism for defining and setting the values of inputs that are required by a form at startup. Form parameters are variables of type CHAR, NUMBER, or DATE that you define at design time.

A built-in package procedure named CREATE_PARAMETER_LIST create a parameter list and return the memory address of the parameter list. A variable of type PARAMLIST must be declare to hold the memory address returned by the function.

Each parameter list created using CREATE_PARAMETER_LIST() must be assigned a unique name. A parameter list can be referenced by its ‘Name’ or ‘Variable’ that holds the pointer to parameter list.

A build in package procedure ADD_PARAMETER add parameter to the parameter list. This procedure accepts the following parameter:

A.    Name of the parameter list

B.    Name of the parameter

C.    Type of parameter

D.    Value of the parameter

e.g.

Declare

Client_list paramlist;

Begin

Client_list := create_parameter_list(‘client_info’);

Add_parameter(client_list,’p_client_no’,text_parameter,’C00001’);

End;