I am writing a java program in which I have to do the Insertion into a table through stored procedure . My problem is that if a duplication of the row occurrs in the table while inserting the data it will throw an exception which i should catch anyhow because on the basis of that data will be added to the list (Those data which are duplicate in the table) I am writing the codes in java.
Please show me some way to do that and please do not use cobol for that.
thanks and regards
Ashish

You can do that with a SQL Stored Procedure. Look in the manual for examples.

Andy