Hi All,

I am using sequence to insert the Primary Key into a table,Some times it
will
give unique constraint error saying that PK already exists(chances are there
some
one might inserted the value manulay) how to generate the sequence which is
always
diif from the one exists in the table.without firing any select statements
before the sequence
generation that is synchronization is possible. I can use trigger but the
development people
are saying that after the insertion of the record they need to fire the
query to findout the id that is
generated .plz let me know how to solve this problem


Regds
Ramki


Oracle LazyDBA home page