Re: How to set trigger status "valid" on Oracle 9i

show error trigger <triggername> works in sqlplus. As you can see when you run the script below:

drop table trgerror1;
create table trgerror1 (c1 number);
drop table trgerror2;
create table trgerror2 (c1 number);

create or replace trigger trg_trgerror
before insert on trgerror2
declare
 lcol trgerror1.c1%TYPE;
begin
 null;
end;
/
drop table trgerror1;

alter trigger trg_trgerror compile;
show error trigger trg_trgerror

Regards,

--
Andre van Winssen