Re: trigger syntax for table

Let me repost so it makes sense:
I am trying to set a trigger so that upon update or delete the triger checks to make sure the "userid" is really the owner of the data. I am doing following plsql script and i keep getting several errors. please help. create trigger user_tri
[Quoted] before update or delete on table_name
declare
  user_id_error;
begin
  if :new.column_name <> user then
raise user_id_error;
end if;
Exception
when user_id_error then
raise application_error (-20001,
[Quoted] 'You do not own this resume.');
end; Received on Fri Aug 06 1999 - 05:41:37 CEST