Re: need help in PL/SQL trigger

Sybrand Bakker wrote:

> On Wed, 04 Dec 2002 16:28:46 +0000, shtng <member_at_dbforums.com> wrote:
>
> >I am a newbie in SQl. I need lots of help. =)
>
> That's why Oracle provides manuals.
> >
> >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?
>
> You simply can't do that. Triggers fire in the database and have no
> interaction with the client. You need to develop a client program to
> allow for user input.
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address

You are assuming he is in SQL*Plus. Given that this was posted in c.d.o.tools I was willing to grant that he might be in some version of Forms. But at this point I don't think the answer is clear.

If you are correct ... so is your answer.

Daniel Morgan Received on Wed Dec 04 2002 - 23:01:13 CET