Re: trigger syntax for table
From: Alexander Romanov <sashar_at_comita.spb.ru>
Date: Fri, 6 Aug 1999 14:48:10 +0400
Message-ID: <7oeeno$qfd$1_at_dragon.infopro.spb.su>
exception 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;
Received on Fri Aug 06 1999 - 12:48:10 CEST
Date: Fri, 6 Aug 1999 14:48:10 +0400
Message-ID: <7oeeno$qfd$1_at_dragon.infopro.spb.su>
Hi
Joet Singh пишет в сообщении ...
>create trigger user_tri
>before update or delete on table_name
>declare
> user_id_error;
^^^^^^^^^^^^^^^^^
exception 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;
Received on Fri Aug 06 1999 - 12:48:10 CEST