I have created a trigger where data cannot be edited on Saturday and Sunday on emp table

Asked Oct 20 '20 at 18:14

Active Oct 20 '20 at 18:27

Viewed 27 times

Create or replace trigger trig_error
before insert or update or delete on emp
begin
     if to_char(sysdate,'DY') IN ('SAT','SUN') then
         raise_application_error(-20111,'No changes can be made on tuesday');
     end if;
end;
dbms_output.put_line('no changes can be done on SAT and SUN!!’);

But getting the output like this: Warning: Trigger created with compilation errors.

edited Oct 20 '20 at 18:27

APC

144,005
19
170
281

asked Oct 20 '20 at 18:14

Keerthi

Errorneous [mysql] tag removed. – Akina Oct 20 '20 at 18:21
1

the `dbms_output` call is outside the trigger body. That's wrong. It's also needless, because the message the user will see is the one from the RAISE_APPLICATION_ERROR() call. – APC Oct 20 '20 at 18:26
What is it you are expecting from the line `dbms_output.put_line(`...... ? – Sujitmohanty30 Oct 20 '20 at 18:27
So, it if is SAT or SUN, you are telling them they can't do this on TUE. ?!?!?!? – EdStevens Oct 20 '20 at 19:59

I have created a trigger where data cannot be edited on Saturday and Sunday on emp table

0 Answers0