Question with Pre-Insert trigger [message #671418] |
Wed, 29 August 2018 03:31 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/04ce8689c5dd4a0f56f99d5c1356c103?s=64&d=mm&r=g) |
RaShi.Raj
Messages: 84 Registered: May 2014 Location: Bangalore
|
Member |
|
|
Hi All,
I have a multi-record DB block. Have written pre-insert trigger which assigns mandatory columns with values. It all works fine when I enter any number of rows and do a commit but throws 'Mandatory column missing error' in this scenario - I add 2 rows -> Delete the 2nd row (DELETE_RECORD) -> Commit.
PRE-INSERT trigger is firing for this particular record but there are NULL values assigned to items which are in PI trigger. Am I missing something?
Thanks,
Rashi
|
|
|
|
|
|
|
|
|
|
|