Re: Triggers and ORA-3113

FabC <fabr.c_at_tiscalinet.it> wrote in message news:<3B94B50E.E0C96FF2_at_tiscalinet.it>...
> Hello,
>
> I'm trying to compile a trigger under oracle 9i (linux) but something
> doesn't work and I dont know why and how to solve.
> I've created a new user/schema (ARCHIVER) who owns 2 table (LOGSTAB and
> STATSTAB). The idea is to have
> a trigger that populate STATSTAB with stats on LOGSTAB after any INSERT
> in it. So I'm using a trigger AFTER INSERT
> on LOGSTAB. The main problem is that I cannot compile the trigger also
> in its basic form:
>
> CREATE OR REPLACE TRIGGER "ARCHIVER"."COLLECTSTATS" AFTER INSERT
> ON "ARCHIVER"."LOGSTAB" FOR EACH ROW
> DECLARE
> n number;
> BEGIN
> select 123 into n from dual;
> END
> /
>
> assuming no syntax error the complier exit with an ORA-3113
> (end-of-channel...)
> I've checked on online docs and the "Errors" book suggest to check the
> syntax but there aren't syntax errors.
> I've tryed also to compile as SYSTEM obtaining the same error (so that I
> guess it isn't a problem of grants).
>
> Any suggestion?
>
> Thanks,
>
> Fabrizio

Fabrizio:

Put a semi-colon (';') at the end of the "END" line thus:

END;
/

It is hitting enf od file prematurely because it is looking for that char.

Also, if you are storing this is a file, make sure there is a CR-LF at the end, after the slash.

Tom Best Received on Tue Sep 04 2001 - 10:00:11 CDT