Ok , so we a currently using oid everywhere in our apps . The problem is that
perodically ... not sure how it happens but the ojb_hl_seq table
gets stamped with a lower id than what is found in our tables . The end result is that
a record exists with this primary key and the record is never inserted .
My question is the follows ... is oid safe and if so does ANYONE have any clue on how
it could eventually start giving out values that already exist (or stamp the
ojb_hl_seq table with a lower sequence value).
ANY HELP WOULD BE GREAT!!!
Serge