I have created a Custom Event for Email. I need the system to send the mail after few minutes from trigger point. Is there any possibility to do that?
+23Hi
yes, it is possible with this chode: dbms_lock.sleep(120);
In my example it will be trigged after 2 minutes.
DECLARE
BEGIN
DBMS_LOCK.SLEEP (120);
END;
+23Hi
can you check if you can see SYS.DBMS_LOCK on your database?
Maybe the package DBMS_LOCK is not installed on you database or you haven’t the permissions.
You should be able to see it with IFSAPP.
I just want to warn you that if you use dbms_lock.sleep the transaction the event is triggered in is also waiting the time you specify.
Depending on which transaction you put this in it can lead to problems with locks, so you need to be careful. Also if this is a transaction in the background job queue it might stop the queue from processing more background jobs.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.