Re: Cannot create Trigger, won't show me errors

> What I am trying is something like:
>
> CREATE OR REPLACE TRIGGER CMS.TRG_ARCHIVE_BI0
> BEFORE INSERT ON CMS.ARCHIVE
> FOR EACH ROW
> BEGIN
> IF ( NVL(:NEW.RECID,0)=0 ) THEN
> SELECT CMS.GEN_GENERAL.NEXTVAL INTO :NEW.RECID FROM DUAL

                                                                  ^

Semikolon after "Dual"?

Grüsse
Uli Received on Sun Oct 16 2005 - 15:20:28 CDT