Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Can't create triggers

Re: Can't create triggers

From: Ken Rachynski <krachyn_at_cadvision.com>
Date: Sat, 10 Oct 1998 14:09:24 -0600
Message-ID: <361fcae9.0@news.cadvision.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US