What are actual and formal parameters in oracle?
Information in subprograms is passed through parameters. If the parameter declared in a subprogram is referenced in the subprogram body, it is called as a formal parameter. On the other hand, when parameters are passed from the calling subprogram, they are actual parameters. The actual and its respective formal parameter should be of the same data type.
Example:Formal parameters being passed
PROCEDURE employee_violation(emp_id INTEGER, violation varchar(200))
{
Procedure definition
}
Calling procedure:
Employee_violation(emp_num, violation); -> Actual parameters are called.
