In this blog post, let’s learn about the error message “11027 Embedded Insert, Update or Delete is not allowed as a trigger event.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
11027 Embedded Insert, Update or Delete is not allowed as a trigger event.
Reason for the Error
An embedded INSERT, UPDATE, or DELETE statement resulted in a trigger event.
The target table of an embedded DELETE statement is the subject table of a DELETE trigger.
The target columns of an embedded UPDATE statement are the subject columns of an UPDATE trigger.
The target columns of an embedded INSERT statement are the subject columns of an INSERT trigger.
Solution
Drop all the triggers defined on the table and operation that caused the error. For example, if the operation is a DELETE, drop all DELETE triggers defined on the DELETE statement target table. If the triggers cannot be dropped, do not attempt these operations
