Re: Newbie, trigger creation [Oracle8.0.5, NT4.0, SP4]?

Hi Thomas,

You need to say what you want to do inside the trigger text, in this case NULL; so the trigger goes like;

    create or replace trigger testtrigger      after insert on bestellungen
    begin

        NULL;
    end;

BTW - This is an after statement trigger as it reads, and fires once for each SQL statement modifying the table, you can also get the trigger to fire FOR EACH ROW. Rgds
Andrew

Thomas Landgraf wrote:

> Hi experts,
>
> i want to create a trigger via SQL Worksheet (Oracle 8.0.5, NT4.0, SP4).
> I wrote the following script:
>
> create or replace trigger testtrigger
> after insert on bestellungen
> begin
> end;
>
> (actually an empty trigger body, just for testing)
>
> When i execute the script, i get this error:
>
> MGR-00072: Warning: TRIGGER TESTTRIGGER created with compilation
> errors.
>
> ..including no hint or linenumber to what i've done wrong. As user "sys"
> i executed BMSSQLX.SQL
> and PUPBLD.SQL before, as i read in the Oracle SQL-Documentation, but
> that did not help.
>
> What am i doing wrong? This cannot be too hard to answer, as i know
> there *are* triggers
> in the real world :)
>
> Please post & reply,
> Thomas
Received on Tue May 04 1999 - 18:57:36 CDT