Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Can't create triggers
Thank you for the tip. Changing the sequence access fixed my trigger.
--
Ken Rachynski
Database Analyst/Developer
krachyn_at_cadvision.com
<http://www.cadvision.com/krachyn>
ICQ: 3113514
Jac. @ xs4all wrote in message <6vngbc$m93$1_at_news2.xs4all.nl>...
>Hi Ken,
>
>sequences can only be used in SQL, not in PL/SQL. So you have to use a
>SELECT statement to retrieve the next value.
>Your trigger will compile it you change it to:
>
>CREATE OR REPLACE TRIGGER COMMS_KEY_BEF_INS_ROW
>BEFORE INSERT ON COMMS_KEY
>FOR EACH ROW
>BEGIN
> SELECT SEQ_COMMS_KEY.NEXTVAL
> INTO :NEW.COMM_ID
> FROM DUAL;
> :NEW.ENTRY_DATE := SYSDATE;
> :NEW.ENTRY_BY := USER;
>END;
>/
>
>Good luck
>
>Jac.
>
>
Received on Sat Oct 10 1998 - 15:09:24 CDT