Hi,
I am using VB and Oracle 8i, when I tried to drop all connection and record locking by issueing
Set rs = nothing and
Set class = new Class....
vb is still having the connection thus having the record locked which I issued a Select for Update but have not commited or rollback. However, when I use the above to drop the connection when connected to SQL, all connections are gone. What can I do to achieve this result in Oracle?
Thanx.
