Question

TCS
IN
Last activity: 16 Jul 2016 9:51 EDT
How to get the DB errors from Exception and separate into sqlcode and error description
I have a requirement where, if user provides invalid data, we need to capture the SQL error produced by the invalid data and show back to user.I want to capture the SQLCODE, MSGCODE returned by the SQL error. How can i achieve and show the message back to user
***Updated by Moderator: Vidyaranjan. Removed user added #helpme tag. Apologies for confusion, shouldn't have been an end-user option***