Table lock for insert triggers?

[gandolf989]

If the table itself is only supposed to have one row, then add a numeric Primary key that gets set to one during the INSERT. You might also have an update trigger that makes sure that it is always set to 1.

CREATE OR REPLACE TRIGGER test 
BEFORE INSERT ON offcparm
   FOR EACH ROW
DECLARE
   :NEW.new_pkey := 1;
EXCEPTION
   WHEN DUP_VAL_ON_INDEX
      mylog('row already exists...BLAH...BLAH...BLAH...');
      RAISE;
   WHEN OTHERS THEN RAISE;
END;
/