Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: trigger problem
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