| trigger created with compilation errors [message #35692] |
Fri, 05 October 2001 22:32  |
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  |
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;
----------------------------------------------------------------------
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
