![Free-eBooks.net](/resources/img/logo-nfe.png)
![All New Design](/resources/img/allnew.png)
create or replace procedure "CHANGE_POSITION"
-- Two temporary I field variables are declared as al, a2
-- IN, OUT, IN OUT will be used for declaring whether to
--- receive input from system or to store or to update followed
--- with data type. Note precision will not be given at
the
--- time of declaration. (al IN NUMBER,
a2 IN NUMBER)
is
--- Any procedure should start with begin and must end with end
--- notation. begin
declare
first_number number;
second_number number;
--- another procedure also can be created within the declaration
--- section.
procedure swaps ( num_one IN OUT NUMBER, num_two IN OUT Number)
is
temp_num number;
begin
temp_num .- num_one; num_one .- num_two; num_two .- temp_num;