Stored Procedure

Drag from the PROCEDURE task node into the canvas, as shown in the figure below:

Task Parameters

Parameter	Description
DataSource	The DataSource type of the stored procedure supports MySQL and POSTGRESQL, select the corresponding DataSource.
Method	The method name of the stored procedure.
Custom parameters	The custom parameter types of the stored procedure support `IN` and `OUT`, and the data types support: VARCHAR, INTEGER, LONG, FLOAT, DOUBLE, DATE, TIME, TIMESTAMP and BOOLEAN.

Prepare: Create a stored procedure in the database, e.g.

CREATE PROCEDURE dolphinscheduler.test(in in1 INT, out out1 INT)
begin
set out1=in1;
END