Re: The trouble with triggers

There are a couple of ways to solve your problem. You are using an undeclared variable.
You can
- declare thedate variable as date, or
- not use the variable, just use sysdate in the Values (....)

To get more info on an error from a compile script you add (on a line, by itself)
show error after the forward slash...
end;
/
show error

Lastly, it is a better practice to list the table columns on an insert statement as in
> insert into historytable (id,name,mydate) values (:new.ID, :new.Name, sysdate);

my opinion. Received on Fri Nov 17 2006 - 12:00:52 CST