Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Trouble with Triggers
Hi,
I want to create a trigger that will write certain columns from a row in table "A" to a separate table whenever a row in table "A is deleted. It will act as a log and as a means of re-creating that record if needed at a later time.
I assume that this can be accomplished thru a trigger, but am having a little trouble in coding it. This is what I have so far...can someone please tell me what is wrong and how to correct it.