Overview Tables Views Indexes Constraints Triggers Procedures Functions Packages Sequences Index

HR


Arguments  Returns  Source  

SECURE_DML

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;


Generated by
OraDoclet, Copyright © Oracle Corporation 2005      Last updated: 01.01.2005