I'm running the following query in a Delphi 7 application using DOA 4.0.7.1 on an Oracle 10G database:

UPDATE BDW.CFG_TBLCONFIG
SET LAST_JOB_NO = 0
WHERE KEYFIELD = 1

It works fine if I run it in an SQL window in TOAD, but never finishes when I run it in the application (either at runtime or design time) or in PL/SQL Developer. It just says "Executing" forever and a day Any ideas?

Regards,

Steve

Did you check if there are any locks?

Hi Marco,

No I didn't. I'm the only one using the database so would locks be a problem? How do I check for locks?

Thanks.

Regards,

Steve

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

Thanks Marco. It seems to be working fine today so maybe there was some sort of glitch at the Oracle end. Last week it would consistently fail, but today it consistently works, without any changes to the code.

Thanks anyway for your help.

Regards,

Steve