Toad World® Forums

Modeler creates broken sequence triggers ....


#1
  1. Create a table, with an ID (integer) field in a Oracle 10G physical model.
  2. Create a sequence.
  3. Go to your field’s properly, and on the bottom, in the “Used Sequence (trigger)” section, choose your sequence. …
  4. Generate DDL script.
  5. 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: shannara@alaska.gov


#2

Hello,

It relates to problem reported here:
http://modeling.inside.quest.com/thread.jspa?messageID=16444&tstart=0#16444

Regards,

Vladka