Perhaps I missed something, but how do I create master-detail relationships when Oracle sequences are used to generate the primary key?. I tried several techniques, including using sql(sequence.nextval/sequence.curval) and nothing seemed to work. All of our PK columns are generated with Oracle sequences. I appears that a child table takes the parent's FORMULA instead of the computed value when data generation occurs. If the VALUE was used by the child, I could use the sequence in the parent, and have the child just take the result.
Data generator with Oracle Sequences
- Thread starter Ken Clubb
- Start date
It is indeed not possible to refer to a master column for which the value is generated on the server at run-time.
Similar threads
- Discussion