Re: Longs in Triggers
From: Daugela <daugela_at_ccinet.ab.ca>
Date: 1995/05/25
Message-ID: <3q0p8j$f6d_at_finzi.ccinet.ab.ca>#1/1
Date: 1995/05/25
Message-ID: <3q0p8j$f6d_at_finzi.ccinet.ab.ca>#1/1
We also had serious problems coping long data types. The best we were able to do was to declare a large varchar2 variable and take the first 32K. PL/SQL will support 32K varchar2, even though tables may only support 2K varchar2.
Darcy Daugela
Roy Enneper <75147.2233_at_CompuServe.COM> wrote:
>We want to place a trigger on a table that has a long column.
>The trigger when fired will compare old and new values and place
>any changed columns into an auditing table. We're able to do
>this with all datatypes except long datatypes, is there anyway
>to implement this for longs?
>--
>Roy Enneper
>Datastream Systems, Inc.
Received on Thu May 25 1995 - 00:00:00 CEST