Procedure Example

Simple Procedure
=================

create or replace procedure proc1(par1 number, par2 number)
is
v_res number;
begin
v_res := par1 + par2;
dbms_output.put_line(v_res);
end;
/


=================================
Simple procedure with table data
=================================

create or replace procedure proc1(par1 number)
is
v_sal employees.salary%type;
v_ann_sal employees.salary%type;
begin
select salary into v_sal from employees where employee_id=par1;
v_ann_sal := 12*v_sal;
dbms_output.put_line(' Annual Salary is: ' || v_ann_sal);
end;
/