Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: trigger problem

Re: trigger problem

From: Fraser Boswell <Fraser.Boswell_at_spamme.ed.ac.uk>
Date: Mon, 21 Jun 1999 09:24:05 +0100
Message-ID: <376DF6A4.234BF039@spamme.ed.ac.uk>


I'm sure I've read here before that you can't refer to long fields in new / old terms. No simple workaround either, unless someone else knows otherwise?

Fraser

leungkw wrote:

> Hi,
>
> I want to refer a LONG type column in a deletion trigger by using:
>
> old.fieldname
>
> ,but everytimes I get the null result. It seem that LONG type column
> cannot be used with old value.
>
> So, what can I do now?
>
> Q1. Can I use LONG type column with old value?? If yes, how?
> Q2. Is there an alternative to do the same work?
>
> thank a lot!!
Received on Mon Jun 21 1999 - 03:24:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US