Calling Stored Procedures or Functions

You can call a stored subprogram from a BEGIN ... END block or from another subprogram or a package.

When calling a stored procedure or function, you can write the actual parameters using the following type of notation:

Positional notation: You specify the same parameters in the same order as they are declared in the procedure. This notation is compact, but you must specify the parameters (especially literals) in the correct order.
Named notation: You specify the name of each parameter and its value. An arrow (=>) serves as the association operator. The order of the parameters is not significant.
Mixed notation: You specify the first parameters with positional notation, then switch to named notation for the last parameters.

Example: Techniques for Calling Stored Procedures or Functions shows how you can call the stored procedure in Example: Creating a Stored Procedure That Uses Parameters.

Techniques for Calling Stored Procedures or Functions

-- use a PL/SQL block to execute the procedure
BEGIN
  award_bonus(179, 0.05);
END;
/
-- using named notation for the parameters, rather than positional
BEGIN 
  award_bonus(bonus_rate=>0.05, emp_id=>123); 
END;
/

You can also call procedures and functions from pages created with Application builder.