Print Thread
"Frozen" Query
#9246 05/11/07 04:56 AM
Joined: May 2004
Posts: 23
Australia
S
Speed Offline OP
Member
OP Offline
Member
S
Joined: May 2004
Posts: 23
Australia
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

Re: "Frozen" Query
#9247 05/11/07 06:20 PM
Joined: Aug 1999
Posts: 22,175
Member
Offline
Member
Joined: Aug 1999
Posts: 22,175
Did you check if there are any locks?


Marco Kalter
Allround Automations
Re: "Frozen" Query
#9248 05/14/07 05:11 AM
Joined: May 2004
Posts: 23
Australia
S
Speed Offline OP
Member
OP Offline
Member
S
Joined: May 2004
Posts: 23
Australia
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

Re: "Frozen" Query
#9249 05/14/07 10:17 PM
Joined: Aug 1999
Posts: 22,175
Member
Offline
Member
Joined: Aug 1999
Posts: 22,175
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


Marco Kalter
Allround Automations
Re: "Frozen" Query
#9250 05/15/07 02:49 AM
Joined: May 2004
Posts: 23
Australia
S
Speed Offline OP
Member
OP Offline
Member
S
Joined: May 2004
Posts: 23
Australia
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


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.027s Queries: 14 (0.007s) Memory: 2.5106 MB (Peak: 3.0377 MB) Data Comp: Off Server Time: 2024-03-29 12:13:49 UTC
Valid HTML 5 and Valid CSS