Home » SQL & PL/SQL » SQL & PL/SQL » trigger created with compilation errors
trigger created with compilation errors [message #35692] Fri, 05 October 2001 22:32 Go to next message
Nirmaljohn
Messages: 1
Registered: October 2001
Junior Member
Hi All,

I have trigger like this with the above warning message. Could anyone help me out in this regard.

My Trigger is:

SQL> create or replace trigger t_t
2 before insert on t
3 begin
4 select count(*) from t;
5 end;
6 /

Warning: Trigger created with compilation errors.

Thanks,
Nirmal

----------------------------------------------------------------------
Re: trigger created with compilation errors [message #35695 is a reply to message #35692] Sat, 06 October 2001 05:03 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
i dont know what you want to do with that trigger, but here is modified code.

create or replace trigger t_t
l_count number(6);
before insert on t
begin
select count(*) into l_count from t;
end;

----------------------------------------------------------------------
Re: trigger created with compilation errors [message #35700 is a reply to message #35692] Sun, 07 October 2001 20:57 Go to previous message
Nirmal
Messages: 39
Registered: November 2000
Member
Thanks Mr. Suresh.

----------------------------------------------------------------------
Previous Topic: Why can't u use dynamic sql?
Next Topic: File in the Client Side
Goto Forum:
  


Current Time: Sat May 25 15:08:38 CDT 2024