Howdy, Stranger!

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

Categories

Do not allowed update

DarkstormDarkstorm Member Posts: 28
Hi!

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


Comments

  • nneomanneoma Member Posts: 61
    : 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.