DBMS_LOCK.SLEEP


/* The following code creates a 5 second delay using DBMS_LOCK.SLEEP */
&s = 5;
SQLExec("exec DBMS_LOCK.SLEEP(:1)", &s);

The process will run and give a data conflict error in the peoplecode step of the App Engine yet when you run the app engine with a trace it seems to run without a problem.  The save is processing so fast that 2 or more transactions is happening at the same time to delay the save use code to delay.

Comments