Re: Instead of triggers on Oracle Personal 8.0.4

Hi Igor,

Your receipt will not work. Correct one is

create or replace trigger tIB_Definition before insert on Definition
for each row
begin
 select seq_Definition.nextval into :new.Definition_SeqNum from dual; end;
/

Andrew Protasov

> َز 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 - 11:24:23 CST