Define 'out' parameters : Parameter OUT « Stored Procedure Function « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Stored Procedure Function
  3. Parameter OUT

Define 'out' parameters

   

SQL>
SQL> create or replace
  2  procedure swap( p_parm1 in out number, p_parm2 in out number ) as
  3  --
  4    l_temp number;
  5  begin
  6    l_temp := p_parm1;
  7    p_parm1 := p_parm2;
  8    p_parm2 := l_temp;
  9  end swap;
 10  /
SQL>
SQL>
SQL>








Related examples in the same category

1.Using out parameter
2.Use out parameter to get value out
3.Parameter Modes
4.Out with NOCOPY modifier.
5.Unhandled exceptions and OUT variables
6.behavior of unhandled exceptions and OUT variables.
7.Behavior of OUT variables and raised exceptions
8.Using Output Parameters
9.This procedure takes a single OUT. Out parameter is assignable
10.Out parameter is assignable