positional and named notation for procedure calls.
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(v_Variable1, v_Variable2, v_Variable3, v_Variable4);
8 END;
9 /
PL/SQL procedure successfully completed.
SQL>
SQL>
Related examples in the same category