Call a stored procedure then other statements : Procedure Call « Stored Procedure Function « Oracle PL / SQL





Call a stored procedure then other statements

   
SQL>
SQL> create or replace procedure swap(
  2    p_parm1 in out number,
  3    p_parm2 in out number ) as
  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  /

Procedure created.

SQL>
SQL> set serverout on
SQL>
SQL> declare
  2   l_num1 number := 100;
  3   l_num2 number := 101;
  4  begin
  5   swap( l_num1, l_num2 );
  6   dbms_output.put_line( 'l_num1 = ' || l_num1 );
  7   dbms_output.put_line( 'l_num2 = ' || l_num2 );
  8  end;
  9  /
l_num1 = 101
l_num2 = 100

PL/SQL procedure successfully completed.

SQL>

SQL>

   
    
  










Related examples in the same category

1.Call a stored procedure in a PL/SQL block
2.Dependency Example
3.Forward Declarations
4.Exceptions in Subprograms
5.A PL/SQL procedure with no parameter
6.Exception throwed out of procedure call
7.Default parameter value
8.Pass parameter by data type
9.Calling ParameterLength illegally (ORA-6502)...
10.Use named notation
11.Use named notation, but with a different order of the formal parameters
12.This script demonstrates how to create and call a simple procedure.