Re: need help in PL/SQL trigger
From: Matthias Rogel <rogel_at_web.de>
Date: Thu, 05 Dec 2002 12:40:00 +0100
Message-ID: <asndui$sieig$1_at_ID-86071.news.dfncis.de>
end;
/
Date: Thu, 05 Dec 2002 12:40:00 +0100
Message-ID: <asndui$sieig$1_at_ID-86071.news.dfncis.de>
create trigger tr_eii
before insert on customer
for each row
begin
if :new.InsuranceInfo is null then
raise_application_error( -20999, 'Dear User, you have to Enter Insurance Info;' || 'Once entered, your input will be accepted.');end if;
end;
/
shtng wrote:
> Hi SQL users,
>
> I am a newbie in SQl. I need lots of help. =)
>
> I am trying to create a trigger, when INSERT is done to add a new
> customer in CUSTOMER table, the trigger is suppose to fire and display
> messages to the user to enter more information.
> How do I display a message to the user such as "Enter Insurance info"
> and accept the input that will be entered in a table?
>
> --
> Posted via http://dbforums.com
Received on Thu Dec 05 2002 - 12:40:00 CET