Re: Trigger created with compiler error (Ora9i)

odette.h_at_gmx.de (odette) wrote in message news:<66e0618e.0202110453.47a03e2d_at_posting.google.com>...
> If I try to execute a local script on the SQL *Plus Worksheet to
> create a trigger, I alway get the warning: Trigger created with
> compiler error.
> Is this an Oracle problem or is it that my sql source code is wrong?
> Here is my source code, please help!
>
> CREATE or replace TRIGGER "xxx"."name" AFTER
> INSERT ON "xxx"."tablename"
> FOR EACH ROW begin
> insert into table
> ( user,
> action,
> table,
> old,
> new,
> time)
>
> values
> ( principal_name,
> 'insert',
> 'table',
> '',
> :new.id,
> '02.02.02');
> end;

Hello,

If you add SHOW ERROR after each create statement, sqlplus will give you feedback about compilation errors.

You may also use SHOW ERROR <object type> <object name>

I don't see anything wrong on the trigger but may be the SHOW ERROR will make it clear.

Edzard Received on Mon Feb 11 2002 - 15:20:30 CST