|
HR |
||||||||||||
|
|
|||||||||||||
| Arguments Returns Source |
| Code |
1 :PROCEDURE secure_dml
2 :IS
3 :BEGIN
4 : IF TO_CHAR (SYSDATE, 'HH24:MI') NOT BETWEEN '08:00' AND '18:00'
5 : OR TO_CHAR (SYSDATE, 'DY') IN ('SAT', 'SUN') THEN
6 : RAISE_APPLICATION_ERROR (-20205,
7 : 'You may only make changes during normal office hours');
8 : END IF;
9 :END secure_dml;
|