Re: Oracle 9i sequence + pre-insert forms trigger

"Mary DeMilia" <mary_at_demilia.com> wrote in message news:34Kaa.109562$If5.4604760_at_twister.southeast.rr.com...
> Hey folks,
>
>
> I created the following sequence:
>
> CREATE SEQUENCE department_seq
> INCREMENT BY 1 start with 1 maxvalue 99999 NOCYCLE;
>
> then I created a pre-insert trigger in Oracle 9i Forms:
>
> BEGIN -- Get the next value for DNUMBER from the -- department_seq
sequence.
> SELECT department_seq.nextval INTO :department.DNUMBER FROM dual;
> END;
>
>
> When I connect and compile I get the following error:
>
> Error 201 line 2, column 9
> identifier 'Department_seq.nextval' must be declared
> Error 0 at line 2, column 2
> SQL statement ignored
>
> What is wrong? Is it the connect? HELP!!!!
>
>
>
>

likely causes:
you are not connected as the owner of the sequence and you have no SELECT privilege on the sequence and/or no synonym.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address