Stored Procedure Item
This item type is an SQL Item for querying the SQL database using select statements.
The item type has the following properties:
| Name | Description | ID | Flags |
|---|---|---|---|
| Stored procedure | The name of the stored procedure on the SQL server | 18653 | Persisted |
The item type exposes stored procedures from an SQL server into an OPC UA namespace. It is configured by adding items in APIS that specifies the name of the stored procedure that is to be exposed. The parameters from the stored procedure is infered onto the First method exposed in the OPC UA namespace.
The available stored procedures can be browsed when adding new Stored procedure items in APIS.