Triggers and ORA-3113

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 Received on Tue Sep 04 2001 - 06:03:43 CDT