TOracleQuery's execute freezes

[mlheureux]

Hi all, I have a problem with a TOracleQuery that reezes whenever the Execute method is executed.

Here's my query :

UPDATE TUTILISATEUR
SET Modifie = 1
WHERE Login IN (SELECT Login FROM TDANS
WHERE UPPER (Code_groupe) = UPPER Groupe))

I used the Oracle Monitor and I can see the program is really freezing on that particular query. And I also see that the variable's value is correct.

This exact same query worked all right with the BDE, and I have lots of TOracleQuerys that are working fine within that application, but this one always freezes and I have no idea why

Thanks for any idea

Martin L'Heureux

 

[Marco Kalter]

Could this be a locking issue or a performance issue? I can

 

[mlheureux]

How can I determine if it's a locking issue ?? I haven't done anything particular about this, so maybe the default values aren't correct for me.

Are there any tool or query that I could use to see if the record I'm trying to update is locked ??

BTW, I'm using D5 with Oracle 7.3.4.4.

Martin

Originally posted by mkalter:
Could this be a locking issue or a performance issue? I can

 

[Marco Kalter]

You can execute the following query to find locks:

select l.*, o.owner object_owner, o.object_name
from sys.all_objects o, v$lock l
where l.type = 'TM' and o.object_id = l.id1

------------------
Marco Kalter
Allround Automations

 

[mlheureux]

Follow-up ...

The problem just dissapeared. It lasted for 2 days, and then everything was working fine.

So right now, the problem's not there anymore, and I don't have much time to spend trying to understand what was going on, I'll just hope it's really gone and it won't come back !!!

Thanks for your help

Martin

 

[Marco Kalter]

If the database has been up during these days, then it might indeed have been a lock.

------------------
Marco Kalter
Allround Automations