Passing parameter by parameter name
SQL>
SQL> CREATE OR REPLACE PROCEDURE CallMe(
2 p_ParameterA VARCHAR2,
3 p_ParameterB NUMBER,
4 p_ParameterC BOOLEAN,
5 p_ParameterD DATE) AS
6 BEGIN
7 NULL;
8 END CallMe;
9 /
Procedure created.
SQL>
SQL> DECLARE
2 v_Variable1 VARCHAR2(10);
3 v_Variable2 NUMBER(7,6);
4 v_Variable3 BOOLEAN;
5 v_Variable4 DATE;
6 BEGIN
7 CallMe(p_ParameterA => v_Variable1,
8 p_ParameterB => v_Variable2,
9 p_ParameterC => v_Variable3,
10 p_ParameterD => v_Variable4);
11 END;
12 /
PL/SQL procedure successfully completed.
SQL>
Related examples in the same category