| Author |
How to set a timer in PL/SQL
|
|
| Jpmill 2006-03-27, 11:24 am |
| I want to code a timer in a proc.
We a running under Oracle 8.1.7 and the function DBMS_ALERT doesn't
exists in 8.1.7.
Is there a way to achieve this?
Thanks
| |
| Mark D Powell 2006-03-27, 11:24 am |
| The package dbms_alert has existed since version 7.0. Have it added to
the database if you need it.
The package dbms_lock contains a sleep procedure.
Again if the package is not here have it added or the execute privilege
granted to the proper username.
HTH -- Mark D Powell --
| |
| DA Morgan 2006-03-27, 8:24 pm |
| Jpmill wrote:
> I want to code a timer in a proc.
>
> We a running under Oracle 8.1.7 and the function DBMS_ALERT doesn't
> exists in 8.1.7.
>
>
> Is there a way to achieve this?
>
> Thanks
It never fails to amaze me when I see people write things such as:
"and the function DBMS_ALERT doesn't exists in 8.1.7."
http://download-west.oracle.com/doc...36/dbms_ale.htm
Actually it existed before 8.1.7 but what does DBMS_ALERT have to do
with the problem as you've stated it?
You will need to far better describe what you want for anyone to help
you.
But before you do ... bookmark:
http://www.oracle.com/pls/tahiti/homepage?remark=tahiti
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)
| |
| Jpmill 2006-03-27, 8:24 pm |
| that's ok I found it !
It's beacause someone said to me that I could code a timer with
DBMS_ALERT.WAITONE('TIMER', alert_msg, alert_status, 5)
it does a 5 second timer.
| |
| DA Morgan 2006-03-27, 8:24 pm |
| Jpmill wrote:
> that's ok I found it !
>
> It's beacause someone said to me that I could code a timer with
> DBMS_ALERT.WAITONE('TIMER', alert_msg, alert_status, 5)
>
> it does a 5 second timer.
Take a look at DBMS_LOCK.SLEEP too.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)
|
|
|
|