local procedure example 1

-- perform sum of two number using procedure
DECLARE
    no1 NUMBER;
    no2 NUMBER;
    ans NUMBER;
    PROCEDURE prc_sum(a IN NUMBER,b IN NUMBER,c OUT NUMBER)
    IS
        BEGIN
            c:=a+b;
        END prc_sum;
BEGIN
    no1:=&no1;
    no2:=&no2;
    prc_sum(no1,no2,ans);
    DBMS_OUTPUT.put_line(ans);
END;
/