When the instruction was executed after the DB Connection Service was shut down or while the DB
Connection Service was being shut down
When the value of the DBConnection input variable is invalid or the specified DB Connection is
already closed
When the TableName input variable is a text string consisting of NULL characters (16#00) only
When a space character is included in the text string specified for the TableName input variable.
When the Where input variable is a text string consisting of NULL characters (16#00) only
When the value of the Timeout input variable is outside the valid range
When a value that is over T#180s was specified in the TimeOut input variable
When the executed SQL statement resulted in an error in the DB
When the DB Connection Service cannot communicate with the DB due to a network failure or other
causes
When one or more SQL statements are already stored in the Spool memory
When the instruction was not completed within the time specified in the TimeOut input variable
When the instruction was executed before completion of the DB’s processing for the DB Connection
Instruction Execution Timeout that occurred for the previous DB_Insert, DB_Update, DB_Select, or
DB_Delete instruction
When more than 32 DB Connection Instructions were executed at the same time
Sample Programming
This section gives sample programming of the following operations for Oracle database.
Retrieve production data for the specified lot number from a DB table when the trigger variable changes to
TRUE.
Delete the records other than the latest one if more than one record was retrieved.
DB Connection Settings and Data Type Definition
The minimum settings necessary for the sample programming are shown below.
DB Connection Settings
DB Connection name: MyDatabase1
Structure Data Type Definition
To Next Page
Loading...
Need help?
General
