To simulate your Oracle stored procedure taking 15 minutes to execute, put this in your sproc:
dbms_lock.sleep(15 * 60);
But first you’ll need to give your user EXECUTE permissions on the dbms_lock module:
C:\>sqlplus sys@clayoracle3 as sysdba ... SQL> GRANT EXECUTE ON dbms_lock TO my_user; Grant succeeded.
If you’re trying this out outside a sproc, put an
exec on the beginning, thus:
exec dbms_lock.sleep(15 * 60);
Note: dbms_lock.sleep() is known to be unreliable past about a 10 minute nap.