Hallo Ramakrishna,

I am not sure about your problem.
Do you know about: Inserting Using Bind Variables Example

From the docs:
The following example returns the values of the inserted rows
into output bind variables :bnd1 and :bnd2:

INSERT INTO emp VALUES (empseq.nextval, 'LEWIS', 'CLARK',
7902, SYSDATE, 1200, NULL, 20)
RETURNING sal*12, job INTO :bnd1, :bnd2;

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

cu
Wieland mailto:[Email Address Removed]Oracle LazyDBA home page