handling errors

["Brickl, Maria" <mbrickl@UWC.EDU>]

How does one handle errors such as the unique constraint error in SQR
programs. I know there will be a unique constraint on the following program
if I try loading values which are already in the table. What I would like to
get is a message saying that those values are already loaded rather than the
oracle errror you get. And then have it End the program and maybe write
duplicate values to a error report.

Where in your program do you put that? And what is the coding?

*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~
Maria K Brickl
Information Systems Programmer/Analyst
University of Wisconsin Colleges
780 Regent St, PO Box 8680, Madison, WI  53708-8680
Phone: 608.265.2677 / Fax: 608.265.5770
*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*