Input and ouput parameters can be specified in SQL statement execution to pass and return values to/from stored procedures, according to the database type:
EXECUTE stmt USING param1 IN, param2 INOUT, param3 INOUT