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

Mary DeMilia wrote:

> 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!!!!

What schema owns the sequence? Is it the same one you are using when you log on with your Form?

Daniel Morgan Received on Sun Mar 09 2003 - 19:22:26 CET