To help us help you, post the DDL extract of your database or the SQL script
that creates your database. I suspect you might have a trigger that fires
off code that produces this exception. In other words, it may not directly
have anything to do with your update statement.

Also, show us again what the SQL statement you are using and the exact
component you are executing it with.

It could also be very helpful if you included the SQL trace prior to and
including the exception as well.

If you don't know how to do any of the above, please search the archives of
this list. If that doesn't produce the help you need then ask here for any
clarification you need. IBO's been around over 8 years and these steps are
whipped to cream in the archives.

Jason Wharton