CREATE PROCEDURE my_proc (IN P1 INT, IN P2 INT DEFAULT 1, OUT out1 DUMMY) AS BEGIN  out1 = SELECT :P1 + :P2 AS DUMMY FROM DUMMY;END;

While calling the procedure, we need to pass 'Named Parameters' with token (=>).

CALL my_proc (P1 => 3, out1 => ?)

If you want to specify all the input fields then call statement would be: CALL my_proc (3, 4, ?)

Related questions