Re: Trigger won't allow use of a sequence

Lee Crampton wrote:

> I have a trigger in which I want to say:
>
> mycolumn := mysequence.NEXTVAL;
>
> This results in a trigger compilation error (and that's all the help you get
> ! ).
> I must be misssing something subtle (?).
>
> Any clues gratefully received.
> Thanks in advance.
> Lee

Try:

    select mysequence.NEXTVAL into mycolumn from dual; Received on Tue Jan 08 2002 - 12:36:54 CST