Using table of references to the sequences instead of table rows for generating sequeneces avoiding
Hello,
Would like to replace the generating next sequence value mehcanism implented with storing current values in tables with sequences.
But since the number of categories to be sequenced is bigger that would demands a lot of sequences and decision-retrieving logic that would decide for the right sequence
( dynamic sql to choose the right sequence name in select ...into ...from dual ).
Should I consider any special resource exception for use of
greater number of seuquences, possible ddl locks during dynamic pl/sql ?
Grateful for any idea, reference or experience,
Regards Ivan
Would like to replace the generating next sequence value mehcanism implented with storing current values in tables with sequences.
But since the number of categories to be sequenced is bigger that would demands a lot of sequences and decision-retrieving logic that would decide for the right sequence
( dynamic sql to choose the right sequence name in select ...into ...from dual ).
Should I consider any special resource exception for use of
greater number of seuquences, possible ddl locks during dynamic pl/sql ?
Grateful for any idea, reference or experience,
Regards Ivan
0