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

Home -> Community -> Usenet -> c.d.o.server -> Re: New to DB Triggers..can U find the error?

Re: New to DB Triggers..can U find the error?

From: Dmitriy B. Agafonov <dagafono_at_rgti.com>
Date: 1997/08/21
Message-ID: <33FC5CC4.5996129D@rgti.com>#1/1

The use of the sequence is not a problem as far as I understand. You can use 'a_sequence.nextval' and 'a_sequence.currval' in a 'values' clause.
To detect the problem try 'show errors trigger trig_address_load'

Regards.

Dmitriy Agafonov. Received on Thu Aug 21 1997 - 00:00:00 CDT

Original text of this message

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