Re: TRIGGER:... created with compilation warnings ?... Basic Qs
- From: Kurt Franke <Kurt-Franke@xxxxxx>
- To: VIVEK_SHARMA@xxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Fri, 25 Apr 2008 14:27:27 +0200
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
