Re: ORA-06552 while creating a trigger

From: Arun Mathur <themathurs_at_gmail.com>
Date: 24 Mar 2005 08:46:06 -0800
Message-ID: <1111682766.848739.5670@o13g2000cwo.googlegroups.com>

What version are you running? This worked fine on my development instance. See below:

SQL> conn amathur_at_dbdev
Enter password:
Connected.
SQL> select * from v$version;

BANNER

---

Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for Solaris: Version 9.2.0.1.0 - Production NLSRTL Version 9.2.0.1.0 - Production

SQL> create table test1(a number(3),b timestamp);

Table created.

SQL> create trigger aaa
  2 before insert on test1
  3 referencing new as new
  4 old as old
  5 for each row
  6 begin
  7 null;
  8 end;
  9 /

Trigger created. Received on Thu Mar 24 2005 - 10:46:06 CST