Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2011

    Unanswered: Exception handling in a stored procedure while inserting into a table

    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

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 5
    You can do that with a SQL Stored Procedure. Look in the manual for examples.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts