PL/SQL Procedure Input / Output

Example

CREATE OR REPLACE PROCEDURE calculate_stats(
  p_num1 IN NUMBER,
  p_num2 IN NUMBER,
  p_num3 IN NUMBER,
  p_sum OUT NUMBER,
  p_average OUT NUMBER
) AS
BEGIN
  p_sum := p_num1 + p_num2 + p_num3;
  p_average := p_sum / 3;
END calculate_stats;
/

Usage

DECLARE
  v_sum NUMBER;
  v_average NUMBER;
BEGIN
  calculate_stats(10, 20, 30, v_sum, v_average);
  DBMS_OUTPUT.PUT_LINE('Sum: ' || v_sum);
  DBMS_OUTPUT.PUT_LINE('Average: ' || v_average);
END;
/