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

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 Mon May 03 1999 - 08:39:31 CDT