Execute Stored Procedure

Operation Name

Execute Stored Procedure

Function Overview

Run the stored procedure.

Data Model

Data model of this type of component is table model type.

Properties

For information about using variables, refer to "variables".
Basic settings
Item name Required / Optional Use of Variables Description Remarks
Name Required Not available Enter the name on the script canvas.  
Input data Optional Not available Select the component on the script canvas.
  • Specify if the specified stored procedure is defined with input parameters.
Required settings
Item name Required / Optional Use of Variables Description Remarks
Destination Required Not available Select Global Resources.
  • [Add]:
    Adds new global resource.
  • [Edit list]:
    Global resource settings can be edited by "Edit resource list".
  
Procedure Required Available Select or enter the name of the procedure to execute.
  • The maximum number of tables listed is determined by Global Resource settings.
Input Optional - Display the input parameters of stored procedure specified in [Procedure].
  • Specify if the specified stored procedure is defined with input parameters.
  • Parameter names shown in the [Input data] will reflected in the Mapper schema.
Input / Parameter name Required Not available Displays the name of the input parameters.
  • Specify if the specified stored procedure is defined with input parameters.
Input / Type Required Not available Displays the type of input parameters.
  • Specify if the specified stored procedure is defined with input parameters.
  • Displayed in the format of "Native type (Internal data type)" .
    • Native type:
      The data type of each specific RDBMS.
    • Internal data type
      Data type used internally in DataSpider.
      Refer to Internal data type for details.
Output Optional - Display the output parameters of stored procedure specified in [Procedure].
  • Specify if the specified stored procedure is defined with output parameters.
  • Parameter names show in the [Output data] will be reflected in the Mapper schema.
Output / Parameter name Required Not available Displays the name of the output parameter.
  • Specify if the specified stored procedure is defined with output parameters.
Output / Type Required Not available Displays the type of output parameters.
  • Specify if the specified stored procedure is defined with output parameters.
  • Displayed in the format of "Native type (Internal data type)" .
    • Native type:
      The data type of each specific RDBMS.
    • Internal data type
      Data type used internally in DataSpider.
      Refer to Internal data type for details.
Property Action
Item name Description Remarks
Launch Table Browser Launches the Table Browser.
For the operating procedure, see Table Browser.
  • Enabled when [Destination] is selected.
Update parameter Update the output parameters of stored procedure specified in [Procedure].
  • In the following cases it can not be executed.
    • If the specified stored procedure does not exist
    • If any variable is specified in [Procedure]
    • If [Procedure] is not entered
    • If error occurs in [Procedure]
Data processing method
Item name Required / Optional Use of Variables Description Remarks
Mass data processing Required Not available Select a data processing method.
  • [Use script settings]: (default)
    Apply mass data processing settings of script property to adapter.
  • [Disable]:
    Mass data processing is not performed.
  • [Enable]:
    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 adapter.
The description will be reflected in the specifications.		  

Schema

Input Schema

Depending on the settings for the [Input data], the number of columns may differ.
See "Schema of Table Model" for details regarding schema structure.

Output Schema

Depending on the settings for the [Output data], the number of columns may differ
See "Schema of Table Model" for details regarding schema structure.

Loading schema in Mapper

Schema is loaded automatically.
For any details, please refer to the 'Editing Schema'

Mass data processing

Mass data processing is supported.

Transaction

Transaction is supported.
Depends on the processing content of the procedure to be performed.The committed data in the stored procedure is not rolled-back.

PSP Usage

PSP is supported.
For details on PSP, refer to "Parallel Stream Processing".

Available Component variables

Component variable name Description Remarks
count Returns the number of executed stored procedure.
  • The value defaults to null.
  • If the specified stored procedure is defined with input parameters, executes stored procedure as much times as the number of input data.
  • Null when using Parallel Stream Processing.
error_code Stores an error code corresponding to occurred SQL exception (SQLException).
  • The value defaults to null.
  • Upon successful completion, "0" is returned.
  • The error code is based on the specifications of each driver vendor.
message_category Stroes the category to which corresponding message code belongs to, when an error occurs.
  • The value defaults to null.
message_code Stores its corresponding message code of occured error.
  • The value defaults to null.
message_level Stores the severity of the corresponding message code of the occured error.
  • The value defaults to null.
error_type Stores the type of the occured error.
  • The value defaults to null.
  • Error is represented in the format depicted below.
    Example:java.io.FileNotFoundException
  • The message may vary depending on the DataSpider Servista version.
error_message Stores the error message for the occured error.
  • The value defaults to null.
  • The message may vary depending on the DataSpider Servista version.
error_trace Stores stack trace of the occurred error.
  • The value defaults to null.
  • The message may vary depending on the DataSpider Servista version or the client application used.

Specification Limits

For the specification limit for each database adapter, refer to "DB adapter Limitations".

Main exceptions

Exception name Causes Solution
ResourceNotFoundException
Resource definition could not be found.Name: []		 [Destination] is not specified. Specify [Destination].
ResourceNotFoundException
Resource definition could not be found.Name: [<name of Global Resources>]		 Resource definition selected in [Destination] is not found. Please check the global resource specified in [Destination]
InvalidPropertyConfigurationException [Procedure] is not set. Please specify [Procedure].
java.sql.SQLException Database access error or other error occurred. Check the message of SQLException.SQLException message is based on the specifications of each driver.SQLException messages may outputs cause of the error.
For more information about the message, please contact each database vendor.

Notes

For the notes for each database adapter, refer to "DB adapter Limitations".