Re: Trigger & Sequence

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 13 Feb 2006 14:50:40 -0800
Message-ID: <1139871036.711627@jetspin.drizzle.com>

Oliver Neumann wrote:

> Error: Query(1/1) ORA-04098: trigger 'SYSMAN.AUTOINC_OBJECT_TEAMS_CLIENT' is
> invalid and failed re-validation

Recompile the trigger.
It will fail.
Type:
SQL> show err

send the complete error text without editing or inserting your interpretation of what it means. Also include your Oracle version. We don't read minds or use Ouija boards.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Mon Feb 13 2006 - 16:50:40 CST