Filter
Top Products
6
FUNCTIONS
6.1 DB Interface Function
6.1.7 Stored procedure call function (Communication action)
6
- 11
1
OVERVIEW
2
SYSTEM
CONFIGURATION
3
SPECIFICATIONS
4
SETTINGS AND
PROCEDURE TO
OPERATION
5
INSTALLATION AND
UNINSTALLATION
6
FUNCTIONS
7
MES INTERFACE
FUNCTION
CONFIGURATION TOOL
8
DB CONNECTION
SERVICE AND
SETTING TOOL
6.1.7 Stored procedure call function (Communication action)
The stored procedure call function starts up a stored procedure in the database.
By executing a stored procedure in the database, the variety and complex control can be
performed for the data in the database.
For the stored procedure call function settings, refer to the following:
Section 7.11.3 Setting items in Communication action (Stored procedure)
The stored procedure call function is used to pass/receive the values to/from the stored
procedure by setting tag components or temporary variables to the arguments (input
arguments, output arguments, and input/output arguments) or return value of the stored
procedure.
When the temporary variable is received a value, it can be used as a variable for other
actions.
(1) Considerations for the stored procedure call function
(a) Database type
The stored procedure call function is supported by the following database types.
• Oracle 10g/11g/12c
• SQL Server 2008/2012
(b) Return value
When the database is Oracle 10g/11g/12c, a stored procedure has no return
value.
If the return value is required, use the output argument or input/output argument.
(c) Commit execution
When the database is Oracle 10g/11g/12c, do not commit in a stored procedure.
Rollback to before the job execution cannot be performed when the job execution
failed.
(For the operation at job execution failure, refer to Section 6.1.11 (2) When
an error occurs in job execution)
A commit is executed by MES interface module after the job completion.
(d) Result set
The result set cannot be acquired from a stored procedure.
For SQL Server 2008/2012, return values, output arguments and input/output
arguments of a stored procedure which returns a result set cannot be acquired.
Figure 6.9 Stored procedure call function (Communication action)
Database server computer
Stored procedure call function
Stored procedure execution request
Tag Component
Temporary variable
Constant
Database
Data
Data
Stored procedure