- Create a table, with an ID (integer) field in a Oracle 10G physical model.
- Create a sequence.
- Go to your field’s properly, and on the bottom, in the “Used Sequence (trigger)” section, choose your sequence. …
- Generate DDL script.
- Run DDL script.
You will notice a compilation error on the .t_seq_ BEFORE INSERT trigger. The error is as follows:
PLS-00302: component ‘SEQ_’ must be declared
Message was edited by: firstname.lastname@example.org