LONGs usage in Triggers

From: Jeremy Ovenden <jovenden_at_hazelweb.co.uk>
Date: Fri, 10 Sep 1999 17:13:44 +0100
Message-ID: <7rbani$2c$1@gxsn.com>

I realise that (certainly up to 8.0.5), you cannot reference :old or :new.longcolumn

I need to transfer information from TABLEA , including the content of a LONG column, into another table TABLEB whenever a a row in TABLEA is inserted or updated. A trigger seemed the obvious choice originally.

How can I implement this - is it possible in real-time or will I have to achieve this via some deferred transaction mechanism?

Thanks......

Jeremy Ovenden
HazelWeb Systems
UK Received on Fri Sep 10 1999 - 11:13:44 CDT