Use named notation, but with a different order of the formal parameters
SQL>
SQL> -- First create a procedure with 4 parameters
SQL> CREATE OR REPLACE PROCEDURE CallMe(pA VARCHAR2,pB NUMBER,pC BOOLEAN,pD DATE) AS
2 BEGIN
3 NULL;
4 END CallMe;
5 /
SP2-0804: Procedure created with compilation warnings
SQL> DECLARE
2 v1 VARCHAR2(10);
3 v2 NUMBER(7,6);
4 v3 BOOLEAN;
5 v4 DATE;
6 BEGIN
7 CallMe(pB => v2, pC => v3,pD => v4,pA => v1);
8 END;
9 /
PL/SQL procedure successfully completed.
SQL>
Related examples in the same category