Procedure and trigger related problems [message #39781] |
Sat, 10 August 2002 11:35 |
Farooq Ahmed
Messages: 5 Registered: June 2002
|
Junior Member |
|
|
Can someone please tell me whether statements like alter trigger or create trigger can be used in a stored procedure because i tried creating a procedure ( see code at the end of text) to alter triggers, but received a warning for compilation errors in creating procedure.
Similarly, some compilation errors were also reported while creating a trigger that was meant to raise an application error. If someone can help me out, I'll be most grateful.
Procedure code:
------------------------
create or replace procedure Disable_Triggers
as
begin
alter trigger FAGO_Trig Disable;
alter trigger FAG_Trig Disable;
alter trigger FAO_Trig Disable;
alter trigger FQ_Trig Disable;
alter trigger QC_Trig Disable;
alter trigger GSettings_Trig Disable;
end;
/
Trigger code:
-------------------------
create trigger QC_Trig
BEFORE DELETE or INSERT or UPDATE
on FEEDBACK_QUESTIONS_CATEGORIES
begin
/*raise_applicaion_error(-20000,'The facility is temporarily unavailable');*/
end;
/
|
|
|
|
|