Trigger problem

From: <joselb_at_my-deja.com>
Date: Thu, 15 Jul 1999 14:45:20 GMT
Message-ID: <7mks5r$hnd$1@nnrp1.deja.com>

Hi,

I want to make an auditory in a table with a long field. I ´m going to create a trigger to save the old and new values in another different table.

Using :new.colum_name :old.column_name. I can save all the values except the long field.

I tried to save the field long value in a variable long type and i receive a error message "table is mutating".

Can you help me ? do you know how do it?

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jul 15 1999 - 09:45:20 CDT