marco wrote:Just after begin add the below code
how do I run procedure only from 9:00 PM till 3:00 AM ?
I mean, procedure should not start if system time is other than "from 9:00 PM till 3:00 AM" even if someone has started it.
if sysdate >= trunc(sysdate)+(21/24) or sysdate <= trunc(sysdate)+(3/24) then raise_application_error(-20001,'Error- You cannot run this procedure now'); end if;
Poeple can call this proceeure at any time of the day, but if they do so between 9:00 PM and 3:00 AM, will return immediately.
... BEGIN IF TO_CHAR (SYSDATE, 'HH24:MI') BETWEEN '03:00' AND '21:00' THEN ... END IF; END proc_x;
if sysdate between trunc(sysdate) and trunc(sysdate)+3/24 or sysdate between trunc(sysdate)+9/24 and trunc(sysdate)+1 then --- do whatever processing you need null; else -- not business hours raise_application_error(-20113,'Not allowed to run X unless between 0 and 3 or 21 and 24 hours!'); end if;