Regarding record locks in oracle. HELP PLEASE!!!!!

Hello:

I was looking for a solution to the problem I am having on Oracle 8.1.6 version on Windows NT 4.0 service pack 6. I have a perl script which checks a control file and runs sqlloader and then runs a sqlplus procedure. The first step (sqlloader) works fine, and when the sqlplus procedure is executed it just sits their does nothing. I have used oracle dba studio GUI and checked to see which sql statment it is running.

When my sql plus procedure is invoked I get a rowid from the control file and pass that as a parameter to my sql plus procedure. But before that I update the same record for some flags using ODBC in perl and I do have a commit after the update. The SQL plus code is supposed to go the control file using the rowid and get additional fields to process. The statement that it is waiting on when I look at the DBA studio is that sql statement. This process is stuck and have let it sit overnight. CAN ONE OF U HELP ME.

I did a v$lock file look up and I see that ctime is 10025, and on ID1 i have a number and their is a tx and tm type locks. How do I rest this so the process continues.

The catch is that some other process which use the same logic works only certain rowid's do not work. ANY HELP IS APPRECIATED.THANKS FOR TAKING TIME TO HELP. THANKS
GIRI GOPAL Sent via Deja.com
http://www.deja.com/ Received on Sat Feb 03 2001 - 13:28:29 CST