Filter:
Submit Search

Execute Stored Procedure

Operation name

Execute Stored Procedure

Function overview

Executes a stored procedure.

Data model

The data model of this component is table model type.

Tutorials

For details about how to create a connection to a MySQL database, refer to the following tutorial:

Properties

= Remarks =

For details on use of variables, refer to Variables.

Basic settings

Item name

Required/Optional

Use of variables

Description

Remarks

Name

Required

Not available

Enter a name that is used on the script canvas.

 

Input data

Optional

Not available

Select a component on the script canvas.

  • Specify when an input parameter is defined in the specified stored procedure.

Required settings

Item name

Required/Optional

Use of variables

Description

Remarks

Destination

Required

Not available

Select a connection resource.

Add

A new connection resource can be added.

Edit list

Connection resource settings can be edited in > HULFT INTEGRATE > Connections.

 

Procedure

Required

Available

Select or enter the name of the procedure to be executed.

  • The number of procedures listed is determined in the settings for connection resources.

Input

Optional

-

The input parameters of the stored procedure specified in Procedure are displayed.

  • Displayed when an input parameter is defined in the specified stored procedure.

  • The parameter names displayed in Input will be displayed in Mapper schema.

Input/Parameter name

Required

Not available

The input parameter name is displayed.

  • Displayed when an input parameter is defined in the specified stored procedure.

Input/Type

Required

Not available

The input parameter type is displayed.

  • Displayed when an input parameter is defined in the specified stored procedure.

  • It's displayed in "<Native type> (<Internal data type>)" format.

    Native type

    RDBMS specific data type.

    Internal data type

    Data type used internally.

    For details, refer to Internal data types.

Output

Optional

-

The output parameters of the stored procedure specified in Procedure are displayed.

  • Displayed when an output parameter is defined in the specified stored procedure.

  • The parameter names displayed in Output will be displayed in Mapper schema.

Output/Parameter name

Required

Not available

The output parameter name is displayed.

  • Displayed when an output parameter is defined in the specified stored procedure.

Output/Type

Required

Not available

The output parameter type is displayed.

  • Displayed when an output parameter is defined in the specified stored procedure.

  • It's displayed in "<Native type> (<Internal data type>)" format.

    Native type

    RDBMS specific data type.

    Internal data type

    Data type used internally.

    For details, refer to Internal data types.

Property actions

Item name

Description

Remarks

Launch table browser

Launch the table browser.

For details about the operation procedure, refer to Table Browser.

  • Enabled when Destination is selected.

Update parameters

Update input/output parameters of the stored procedure specified in Procedure.

  • It can't be executed in the following cases:

    • When the specified stored procedure doesn't exist

    • When a variable is specified in Procedure

    • When Procedure isn't entered

    • When an error has occurred in Procedure

Execution settings

Item name

Required/Optional

Use of variables

Description

Remarks

Enable query timeout

Required

Not available

Select whether or not to enable the query timeout.

Selected

Set the query timeout.

Not selected

(Default)

Don't set the query timeout.

  • When this field isn't selected, the behavior of the JDBC driver when the query timeout isn't set will be applied.

Query timeout (seconds)

Required

Available

Set the query timeout.

  • Enabled when Enable query timeout is selected.

  • Allowed values are from 0 to 2147483647.

  • The value input in this property will be specified as an argument for JDBC setQueryTimout() method.

  • Generally, the seconds to wait for execution is specified for a query timeout, but the behavior might be different depending on the database or the JDBC driver used.

Data processing method

Item name

Required/Optional

Use of variables

Description

Remarks

Data processing method

Required

Not available

Select a data processing method.

Apply script settings

(Default)

The setting for mass data processing in the script properties is applied to the connector.

Do not perform mass data processing

Mass data processing isn't performed.

Perform mass data processing

Mass data processing is performed.

 

Comment

Item name

Required/Optional

Use of variables

Description

Remarks

Comment

Optional

Not available

You can write a short description of this connector.

 

Schemas

Input schema

The number of columns varies depending on the Input settings.

= Remarks =

For schema structure, refer to Table model type .

Output schema

The number of columns varies depending on the Output settings.

= Remarks =

For schema structure, refer to Table model type .

Loading schema in Mapper

The schema is loaded automatically.

= Remarks =

For details, refer to Edit Schema.

Mass data processing

Mass data processing is supported.

Transaction

Transaction is supported.

Note

It depends on the operation details of the procedure to be executed. Data committed in stored procedures will not be rolled back.

Parallel Stream Processing

PSP is supported.

= Remarks =

For details on PSP, refer to Parallel Stream Processing.

Available component variables

Component variable name

Description

Remarks

count

The number of executed stored procedures is stored.

  • The default value is null.

  • When input parameters are defined in the specified stored procedure, stored procedures will be executed for the number of input data records.

Note

Value isn't stored when using PSP.

error_code

When an error (SQLException) occurs, the error code corresponding to the error is stored.

  • The default value is null.

  • 0 is stored when finishing successfully.

Note

Error codes are based on the specifications of each driver.

message_category

When an error occurs, the category of the message code corresponding to the error is stored.

  • The default value is null.

message_code

When an error occurs, the code of the message code corresponding to the error is stored.

  • The default value is null.

message_level

When an error occurs, the severity of the message code corresponding to the error is stored.

  • The default value is null.

error_type

When an error occurs, the error type is stored.

  • The default value is null.

  • The format of the error type is as follows.

    Example: java.io.FileNotFoundException

error_message

When an error occurs, the error message is stored.

  • The default value is null.

error_trace

When an error occurs, the trace information for the error is stored.

  • The default value is null.

Message codes, exception messages, and limitations

Connector

Message code

Exception message

Limitations
Messages and limitations of the MySQL connector

check

check

check

Messages and limitations of the Oracle connector

check

check

check

Messages and limitations of the SQL Server connector

check

check

check

Messages and limitations of the JDBC connector

check

check

check

Messages and limitations of the Amazon Aurora for MySQL connector

check

check

check

Messages and limitations of the Amazon RDS for MySQL connector

check

check

check

Messages and limitations of the Amazon RDS for Oracle connector

check

check

check

Messages and limitations of the Amazon RDS for SQL Server connector

check

check

check

Messages and limitations of the Azure SQL Database connector

check

check

check

Policies     (c) Saison Technology Co.,Ltd. 2021

TOP