Re: TRIGGER:... created with compilation warnings ?... Basic Qs
Date: Fri, 25 Apr 2008 14:27:27 +0200
> 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"
kfReceived on Fri Apr 25 2008 - 07:27:27 CDT