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: ORA-00439: feature not enabled: Instead-of triggers

Re: ORA-00439: feature not enabled: Instead-of triggers

From: Ken Rachynski <krachyn_at_cadvision.com>
Date: Tue, 16 Mar 1999 10:57:20 -0700
Message-ID: <36EE9B80.A89EA1C8@cadvision.com>


You have got to be kidding me. This package is getting more and more expensive all the time. My boss wanted Oracle because he was "familiar" with it. I like a lot of what Oracle can do, but the cost structure leaves much to be desired.

Jonathan Lewis wrote:

> I believe you need the (extra cost) Object option
> installed to use 'instead-of' triggers.
>
> --
>
> Jonathan Lewis
> Yet another Oracle-related web site: www.jlcomp.demon.co.uk
>
> Ken Rachynski wrote in message <36EE8E27.4CBA0CE3_at_cadvision.com>...
> >In an attempt to get around the fact that I cannot copy LONG columns to
> >an archive table within a trigger, I followed Thomas Kyte's suggestion
> >to use an instead-of trigger to do a flag delete. The error message in
> >the subject is what I got for my efforts.
> >

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

Original text of this message

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