Re: Generating unique key numbers

From: "Michal Motalík" <cross_at_zl.inext.cz>
>> CREATE TRIGGER tabtrig

BEFORE INSERT ON tab
FOR EACH ROW
BEGIN
  :NEW.id := tabseq.NEXTVAL;
END;
The sequence "tabseq" was created. I get the error PLS-00357. (reference to sequence is not permitted in these context) Does anybody know where the problem is? <<<

1. Why not just reference the sequence in the insert statement? insert into table_name (key_col, etc...) values ( tabseq.nextval, etc...*)
2. Try using a select into statement instead of pl/sql assignment select tabseq.nextval into v_variable from sys.dual; You should then be able to assign this variable to a row column

Good Luck.
Mark Powell -- Oracle 7 Certified DBA
- The only advise that counts is the advise that you follow so follow your own advise - Received on Sat Nov 29 1997 - 00:00:00 CST