Triggers and catproc.sql

Hi,

The Oracle documentation (Developer's guide - Fundamentals) claims that a prerequisite to use triggers is to run the catproc.sql script.

I had no problem with it in Oracle 8.1.5.

Since I use Oracle 8.1.7, when I run this script, I get some errors ORA-04098 "Invalid trigger SYS.JIS$ROLE_TRIGGERS$, and after that, I get the same error each time I attempt to drop something from the database (drop a user, drop a table, …).

So, I tried using triggers without running this script. And it seems to work !

So : Is catproc.sql required in 8.1.7 ? And how to get rid of these errors ?

Thanks,

Roger.

-- 
leriche_at_abaksystemes.fr
ABAK Systèmes, ZI Le Rachat - BP 5 - 35890 LAILLE
Tel: +33(0) 299.42.30.10, Fax: +33(0) 299.42.31.57