Hey!!

I have a problem in my batch Process which is running in
HP-UNIX 9000 Series (Oracle as Database).I need to run a PL/SQL Loop
on UNIX Environment but it could be stopped whenever the situation arise.
To achieve this i Planned to design a table where the LOOP refers a particular
column while running.I dont know the unix command to do , Please guide me

Here the Example

--- LOOP----

a=`date +%H%M`
flag=true
while $flag
do
" Here I am calling a PL/SQL Loop"
sleep 180
a=`date +%H%M`
Here the variable "b" should be referred from a Table in the Database
if [ $a -ge $b ]
then
flag=false
fi
done


---TABLE---

Table Stucture

SQL> desc user_log
Name Null? Type
------------------------------- -------- ----
USERA VARCHAR2(6)
TIME VARCHAR2(6)
DTEM DATE

The values In the table

SQL> select * from user_log;

USERA TIME DTEM
------ ------ ---------
LOOP 230000 11-MAR-02
CS11 230000 11-MAR-02


I need to refer a "TIME" column where the usera = "LOOP".