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

Hi,

> Following Error Occurred during impdp:-
>
> ORA-39082: Object type TRIGGER:"CRMUSER"."TRG_LCT" created with
> compilation warnings
>
> ACTION:-
>
> 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"

Regards

kf

--
http://www.freelists.org/webpage/oracle-l