Home -> Usenet -> comp.databases.oracle -> SEQUENCE in a TRIGGER

SEQUENCE in a TRIGGER

From: Nathalie <nathalie_at_MAIL.ATCON.COM>
Date: 1996/02/22
Message-ID: <4gidcd$l2f_at_thor.atcon.com>#1/1 






I created a SEQUENCE:



CREATE SEQUENCE NEXT_KEY_GEN INCREMENT BY 1 START BY 1;



and then a TRIGGER for my table TRANSACTION:



CREATE TRIGGER TRIG_NEXT_KEY_TRANSACTION


	BEFORE INSERT ON TRANSACTION
	FOR EACH ROW
BEGIN
	:NEW.P_KEY := next_key_gen.nextval;




END;



and I get the error message "PLS-00357: Table, view or sequence
reference 'NEXT_KEY_GEN' not allowed in this context"



Does that mean that I can't use a sequence generator in a trigger? It
would be quite useful, wouldn't it?  I'd like to use it because I
wouldn't have to worry about primary keys from the Powerbuilder end of
it.



Thanks



Nathalie


nathalie_at_atcon.com



DeltaWare Systems Inc.


Prince Edward Island, Canada
Received on Thu Feb 22 1996 - 00:00:00 CET












Original text of this message