Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> ORA-06552 while creating a trigger
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
![]() |
![]() |