Re: Instead of triggers on Oracle Personal 8.0.4

َز 18 خدر 98 (arivlin_at_my-dejanews.com) wrote:

> I got an error message ORA-00439( feature not enabled ) when I tried to create
> an instead of trigger on Oracle Personal 8.0.4 ( NT4.0 )
> Does anyone know if there is a way around it?

There no way. Instead-of triggers is NOT SUPPORTED in Oracle8 WorkgroupServer and also instead-of tgiggers is not supported in Personal Oracle. This feature is available with Oracle8 Enterprise Server ONLY. You can use V$OPTION system view to check what features is available. By the way, there a lot of differences between Oracle8 Enterprise Server and Oracle8 Workgroup Server. The bitmap indexes, table partitioning and a lot of other features is not available with Oracle8 Workgroup Server. It's seems terrible for me... Oracle7 has a very small difference between Worgoroup and Enterprise edition... But Oracle8... :(

And be carefull: chapter 'Differencies between Oracle8 and Oracle8 Enterprise edition' of my Oracle documentation contains error (according to explanation that I've got at my Oracle support) regarding instead-of triggers.

To Thomas Kute: correct me if I'm wrong pleace.

> I would also appreciate any suggestion how to force a column in a table to be
> always set to sequence.nextval and prevent any kind of SQL+ intervention?

{several statements of SQL-script skipped}

> create or replace trigger tIB_Definition
> instead of insert on Definition
> for each row
> begin
> begin
> insert Definition ( Definition_SeqNum,
> Definition_Type,
> Definition_Name,
> Definition_Value )
> values ( seq_Definition.nextval,
> :new.Definition_Type,
> :new.Definition_Name,
> :new.Definition_Value )
>
>
> end;

You should never use INSERT statement in that cases. Just wrote:

create o replace trigger {...}
begin
  :new.Definition_SeqNum := seq_Definition.nextval; end;

This was discussed at our newsgroup some days ago.

--
Is There A God Or Any Kind Of Justice Under The Sky... (Queen'91)

Igor V. Podolsky (igoryok_at_soft-review.kiev.ua) Received on Sat Nov 21 1998 - 10:22:18 CST