SQL> -- store procedure with three parameters
SQL>
SQL>
SQL> create or replace
2 procedure three_parms(
3 p_p1 number,
4 p_p2 number,
5 p_p3 number ) as
6 begin
7 dbms_output.put_line( 'p_p1 = ' || p_p1 );
8 dbms_output.put_line( 'p_p2 = ' || p_p2 );
9 dbms_output.put_line( 'p_p3 = ' || p_p3 );
10 end three_parms;
11 /
Procedure created.
SQL>
SQL> set serverout on
SQL>
SQL> exec three_parms( p_p1 => 12, p_p3 => 3, p_p2 => 68 );
p_p1 = 12
p_p2 = 68
p_p3 = 3
PL/SQL procedure successfully completed.
SQL>