Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-06552 while creating a trigger

ORA-06552 while creating a trigger

From: Golan <bcg008_at_mot.com>
Date: 24 Mar 2005 01:13:33 -0800
Message-ID: <35e0ae97.0503240113.517063cd@posting.google.com>


I got ORA-06552 while trying to create a trigger. I found that the cause for this error is a field with a timestamp type. For example:
CREATE TABLE TEST1(
 A number(3),
 B timestamp
)
and then
CREATE TRIGGER AAA
BEFORE INSERT ON TEST1
REFERENCING
 NEW AS NEW
 OLD AS OLD
FOR EACH ROW
Begin
null;
End;

/

will cause this ORA-06552.
But if I'll drop column B from the table, all works just fine. Since I need the timestamp definition, maybe someone knows how to prevent this error and stay with the timestamp type?

Thanks in advance Received on Thu Mar 24 2005 - 03:13:33 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US