Re: Why do I always get a compiler error???

On 11 Feb 2002 04:54:19 -0800, odette.h_at_gmx.de (odette) wrote:

>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)
Why This Emmpty Line.... Oracle does Not Allow this. u can always say show errors to see the error.
> values
> ( principal_name,
> 'insert',
> 'table',
> '',
> :new.id,
> '02.02.02');
>end;

HTH
[Additions and Corrections Always Welcome.] Best Regards,
Ganesh R Received on Mon Feb 11 2002 - 15:04:22 CET