Copy a LONG to another table in a trigger?

Good day,

I have a routine that I used to copy the contents of one table to another where both had a LONG column, so I know I can move the LONG data between tables. However, this was for a mass copy of records.

I wrote a trigger (before delete for each row) to insert the record into an archive table. This works fine execpt for the LONG column was the only column not inserted into the archive. How do I insert the data from the current record into the archive table for the LONG column?

I am reading the PL/SQL manual while I await an answer so may discover it for myself.

Thanks in advance for any replies.

--
Ken Rachynski
Database Analyst
krachyn_at_cadvision.com
<http://www.cadvision.com/krachyn>
ICQ: 3113514 Received on Mon Mar 08 1999 - 16:50:20 CST