SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Prevent UPDATE from happening using a trigger

Y.RamletAug 25 2016 — edited Aug 26 2016

RDBMS version: 11.2.0.4

OS : Oracle Linux 6.4

From the application, the following UPDATE statement is fired occasionally.

UPDATE PKT_HDR_STAGING SET PROCESSED_FLAG='Y' WHERE ORDER_NUM IN( 'Q-83847848','Q-13383483','Q-67129302' ) ;

But , due to a bug introduced two days back the update is fired without the WHERE clause !! Developers are currently working on this.

So in the mean time, I would like to implement a trigger which should prevent(abort) any UPDATE statements against this table without a WHERE clause.

How can I do this ?

This table is not a frequently updated table. Its only updated every 2 hours

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 23 2016

Added on Aug 25 2016

6 comments

1,889 views