Re: need help in PL/SQL trigger
Date: Wed, 04 Dec 2002 23:07:14 GMT
Message-ID: <CUvH9.2471$BB7.47550764_at_newssvr13.news.prodigy.com>
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
As you probably noticed, many of your replies are directed at a
different kind of "trigger" - a database trigger. There is no user
interface for a database trigger. If you are using Oracle Forms, then in
that context, a trigger is a different animal. You can display a message
(alert) from the trigger. If you are using J2EE, then you are talking
about an event trigger.
That's the problem when one word has multiple meanings, but your post doesn't clarify which meaning you intended. That's not a bad thing ... just a newbie thing.
Let us know in which context you are using the word and we'll be happy to help. Received on Thu Dec 05 2002 - 00:07:14 CET