ScrewTurn Wiki

Edit

wikibot

ProcedureHR.SECURE_DML

Edit

Source

CREATE OR REPLACE PROCEDURE secure_dml
IS
BEGIN
  IF TO_CHAR (SYSDATE, 'HH24:MI') NOT BETWEEN '08:00' AND '18:00'
        OR TO_CHAR (SYSDATE, 'DY') IN ('SAT', 'SUN') THEN
	RAISE_APPLICATION_ERROR (-20205,
		'You may only make changes during normal office hours');
  END IF;
END secure_dml;

ScrewTurn Wiki version 2.0.36. Some of the icons created by FamFamFam.