Re: ORA-00001: unique constraint (%s.%s) violated - SOLVED

Dereck L. Dietz wrote:
> Problem solved. The source table which was used as the source for the load
> was structurally modified without anybody being notified of the changes.
>
> The error being displayed was a "false" error and had to do with the code
> had been expecting column sizes of 11 and 12 but was receiving columns sized
> 25 and 20 instead.

A table definition was modified without anybody being notified?

I'd say you've got a problem a lot bigger than anything that an exception handler can catch.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org