SQL> create or replace PROCEDURE swapn (num_one IN OUT NUMBER, num_two IN OUT NUMBER) IS
2 temp_num NUMBER;
3 BEGIN
4 temp_num := num_one;
5 num_one := num_two;
6 num_two := temp_num ;
7 END;
8 /
Procedure created.
SQL>