Re: using a sequence inside an insert trigger
From: Steve Butler <sbut-is_at_seatimes.com>
Date: 1995/04/19
Message-ID: <Pine.SUN.3.91.950419120316.24924A-100000_at_seatimes>#1/1
Date: 1995/04/19
Message-ID: <Pine.SUN.3.91.950419120316.24924A-100000_at_seatimes>#1/1
On 18 Apr 1995, Anna Horton wrote:
> no I can't change the project is too far along ). I am trying to mimic
> the action of the automatic counter field using SEQUENCE and an insert
> trigger on the table. PL/SQL does not appear to allow the use of a
> sequence in the body of the PL/SQL. Is a stored procedure and some hack
> on the access side of the equation the only way to do this?
It should work in the straight forward manner. Perhaps you could post the trigger code (or relevant parts)?
+----------------------------------------------------+ | Steve Butler Voice: 206-464-2998 | | The Seattle Times Fax: 206-382-8898 | | PO Box 70 Internet: sbut-is_at_seatimes.com | | Seattle, WA 98111 Packet: KG7JE_at_N6EQZ.WA | +----------------------------------------------------+All standard and non-standard disclaimers apply. All other sources are annonymous. Received on Wed Apr 19 1995 - 00:00:00 CEST