trigger syntax for table
From: Joet Singh <jsingh_at_bigfoot.com>
Date: Thu, 5 Aug 1999 22:03:00 -0500
Message-ID: <Clsq3.1701$3X5.15907_at_insync>
I am trying to set a trigger so that upon update or delete the triger checks to make sure the "userid" is really the other of that data. I am doing following plsql script and i keep getting several errors. please help. create trigger user_tri
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,
'You do not own this resume.');
end;
Date: Thu, 5 Aug 1999 22:03:00 -0500
Message-ID: <Clsq3.1701$3X5.15907_at_insync>
I am trying to set a trigger so that upon update or delete the triger checks to make sure the "userid" is really the other of that data. I am doing following plsql script and i keep getting several errors. please help. create trigger user_tri
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,
'You do not own this resume.');
end;
-- ----------- Joet Singh Business Solutions Group 281-652-9376 281-652-9377 (fax) mailto:jsingh_at_bsgllc.com http://www.bsgllc.comReceived on Fri Aug 06 1999 - 05:03:00 CEST