using a sequence inside an insert trigger
From: Anna Horton <eaglesCo_at_ix.netcom.com>
Date: 1995/04/18
Message-ID: <3n19qh$6uf_at_ixnews1.ix.netcom.com>#1/1
Date: 1995/04/18
Message-ID: <3n19qh$6uf_at_ixnews1.ix.netcom.com>#1/1
OK, I'm at the end of my rope. I am using access as the front end ( and 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? Received on Tue Apr 18 1995 - 00:00:00 CEST