HR SECURE_DML (procedure)

Modified on 2011/08/27 12:09 by wikibot Categorized as Uncategorized

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- valign="top"
| '''Procedure'''
| HR.SECURE_DML
|}

=== Source ===
{{{{<nowiki>
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;
</nowiki>}}}}

devio dbscript ScrewTurn Wiki

Navigation¶

HR SECURE_DML (procedure)