Do not allowed update

Hi!

I would like to write a database trigger that does not allowed any update on the transaction.


Comments

  • : Hi!
    :
    : I would like to write a database trigger that does not allowed any update on the transaction.
    :
    :
    :


    the trigger code should be something like

    create trigger
    before update on
    begin
    raise_application_error(-20000,'Update not allowed on table');
    end;

    let me know if that helped.



Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion