Example

Call procedure proc1 and pass SQL variables as parameters.

    CALL proc1(v_empno, v_salary)