macro recording problem

[marek]

PLS 6.0.2; WinXP
Macro record does not work.
After starting Macro Record (from menu or with button or F11), computer does not react to keyboard or mouse activities. Only after Ctrl+Alt+Del and then Cancel in Windows Security window it is possible to resume.

 

[Marco Kalter]

Works fine for me. Is this reproducible? If so, is it reproducible on other PC's?

 

[marek]

Originally posted by Marco Kalter:
Works fine for me. Is this reproducible? If so, is it reproducible on other PC's?

yes, it is ..
With newly installed PLS in other PC it works fine.

 

[Marco Kalter]

I'm not sure what could cause this.

 

[Bert Gombos]

I face the same problem. (v6.0.3) Until last week it works fine but somethink made it wrong. Maybe a Windows Update (WinXP Pro). I didn't update my system but our system administrator. :-(

 

[Bert Gombos]

Does anybody have any idea to solve this problem? This is a nondeterministic bug, sometimes it appears, sometimes doesn't.

 

[wbennett]

I've had this problem also. Have not yet determined how to reproduce.

 

[Morten Johnsen]

Same problem here, but in version 7.0.
Not able to record macros.

Anybody know how to solve it?

 

[mike]

This started happening to me just after I got my new PC at work. I have PL/SQL Developer Version 7, Windows XP Pro and Microsoft Office 2003.

One time Excel froze up for whatever reason. When I killed Excel, a message box came up asking to submit an error report and recommended updating to Microsoft Office 2003 service pac2.

It's only been a week, but so far, I haven't had any problems recording macros after that. Maybe I'm just lucky, but it might be worth checking into. I think you can go to help/Microsoft online while in an office application and look for updates there.

One other weird thing is that I had the XP Style enabled and I noticed that it was off yesterday. I don't know if I just forgot that I turned it off or what. I don't know if that could do anything, but you might try toggling that off temporarily just to see. I set mine back on and it works, but I thought I would mention it.

Mike

 

[mike]

Well, it happened to me again, so my theory isn't the solution.

Mike

 

[tommm]

Here is my story and my workaround: I had this problem too with PL/SQL Developer version 5.1.4.730 and WinXP, Service Pack 1. After reinstalling PL/SQL Developer the problem disapeared. But when I rebooted my machine, the problem was back.
Some other computer with the same configuration as mine didn't have the problem. So I looked at DLL files in WINDOWS\SYSTEM32 directory. There were 7 DLLs on the other computer which were different than those on my computer. Windows replaced them with other versions:

DLL_FILE       version after PLS install    version after reboot
------------   -------------------------    --------------------
gdi32.dll      5.1.2600.1561                5.1.2600.1346
kernel32.dll   5.1.2600.1560                5.1.2600.1106
ole32.dll      5.1.2600.1619                5.1.2600.1263
rpcrt4.dll     5.1.2600.1361                5.1.2600.1254
shell32.dll    6.0.2800.1634                6.0.2800.1106
SHLWAPI.DLL    6.0.2800.1612                6.0.2800.1106
user32.dll     5.1.2600.1634                5.1.2600.1255

I returned to 'after install' DLL versions and macro recording was working. I have to repeat this workaround after each reboot. Because Windows changes the DLL versions on his own.
Good Luck!

Tom