Stored Procedure

  • Execute the stored procedure according to the selected DataSource.

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

Stored Procedure - 图1

Task Parameters

ParameterDescription
DataSourceThe DataSource type of the stored procedure supports MySQL and POSTGRESQL, select the corresponding DataSource.
MethodThe method name of the stored procedure.
Custom parametersThe 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.

Remark

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

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