Message-Id: <10652.119427@fatcity.com> From: Schoen Volker Date: Tue, 17 Oct 2000 12:00:36 +0200 Subject: URGNET PL/SQL Help: PLS-00357 Hi list, I want to get a value from a sequence in a trigger. If I try the = following trigger, I get PLS-00357 error. Any suggestions? SQL> CREATE OR REPLACE TRIGGER IEINSATZBERICHTE BEFORE INSERT ON EINSATZBERICHTE REFERENCING NEW AS=20 NEW FOR EACH ROW 2 BEGIN 3 :NEW.LFDNR :=3D SQ_EINSATZBERICHTE.NEXTVAL; 4 END; 5 / Warning: Trigger created with compilation errors. SQL> show errors; Errors for TRIGGER IEINSATZBERICHTE: LINE/COL ERROR -------- = ----------------------------------------------------------------- 2/1 PL/SQL: Statement ignored 2/34 PLS-00357: Table,View Or Sequence reference 'SQ_EINSATZBERICHTE.NEXTVAL' not allowed in this context SQL> select SQ_EINSATZBERICHTE.NEXTVAL from SQ_EINSATZBERICHTE; select SQ_EINSATZBERICHTE.NEXTVAL from SQ_EINSATZBERICHTE * ERROR at line 1: ORA-02201: sequence not allowed here TIA Volker Sch=F6n E-Mail: mailto:v.schoen@inplan.de