Re: TRIGGER:... created with compilation warnings ?... Basic Qs

From: Kurt Franke <>
Date: Fri, 25 Apr 2008 14:27:27 +0200
Message-Id: <>


> Following Error Occurred during impdp:-
> ORA-39082: Object type TRIGGER:"CRMUSER"."TRG_LCT" created with
> compilation warnings
> SQL> alter trigger "CRMUSER"."TRG_LCT" compile;
> Warning: Trigger altered with compilation errors.
> SQL> show errors
> No errors.

may be the name in the trigger source is encllosed in double quotes ?

SQL*Plus' show error command without parameter is buggy in the fact that it won't display any error if an code object name is enclosed in double quotes.

in such a case it's necessary to use a parameterized call directly after the error also: show errors trigger "CRMUSER"."TRG_LCT"



Received on Fri Apr 25 2008 - 07:27:27 CDT

Original text of this message