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

simply place a null; in the code as shown:

create or replace trigger testtrigger
after insert on workorder
begin
null;
end;

Thomas Landgraf <thomas.landgraf_at_materna.de> wrote in message news:372DA712.85988368_at_materna.de...
> 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:26:40 CDT