Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Lock one row of a table from all users
George Mansoor wrote:
>
> Is there a way to lock one row of data from all users, permanently?
>
> Thanks
>
> George
create or replace
trigger TRG before update or delete on T
begin
if :old.primary_key = ... then
raise_application_error(-20000,'NO NO NO NO');
end if;
end;
-- Connor McDonald Co-author: "Mastering Oracle PL/SQL - Practical Solutions" ISBN: 1590592174 web: http://www.oracledba.co.uk web: http://www.oaktable.net email: connor_mcdonald_at_yahoo.com Coming Soon! "Oracle Insight - Tales of the OakTable" "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" ------------------------------------------------------------Received on Sun May 16 2004 - 03:22:23 CDT