Home » SQL & PL/SQL » Client Tools » PL/SQL Developer Debugging Hangs (7.1.5.1397 02.50496)
PL/SQL Developer Debugging Hangs [message #325557] Fri, 06 June 2008 10:12 Go to next message
pmcginnis
Messages: 2
Registered: June 2008
Junior Member
PL/SQL Developer Debugging constantly hands when I got to start the debugger and never comes back. Then other times it doesn't. I noticed if I view package/body, recompiled and added debug info 3-4 times, it works, but again, other times it still hangs.

Any help would be greatly appreciated!

Thank You.
Re: PL/SQL Developer Debugging Hangs [message #325565 is a reply to message #325557] Fri, 06 June 2008 10:22 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
I suspect that the annoying symptom ("hang") has nothing to do with Developer itself.

Let us say you have a procedure which does some DML & it gets invoked.
Further this procedure does NOT contain any COMMIT.

Now image in a different window or session try to (re)compile this procedure.
This session will quietly wait until the 1st session issues a COMMIT or ROLLBACK to ensure data integrity.

As POGO once said, "We have met the enemy & they is us (you)."

After confirming this reality, please post results back here.

[Updated on: Fri, 06 June 2008 10:24] by Moderator

Report message to a moderator

Re: PL/SQL Developer Debugging Hangs [message #325569 is a reply to message #325565] Fri, 06 June 2008 10:29 Go to previous messageGo to next message
pmcginnis
Messages: 2
Registered: June 2008
Junior Member
Thanks for your insight, but no, I can open up a PL/SQL Developer session completely new and run some procedure, with or without commits, and I still have the problem. I did notice also that if I turned off, in preferences, update watches after each step, and update call stack after each step, I get better results.

Hmmmm.
Re: PL/SQL Developer Debugging Hangs [message #325600 is a reply to message #325569] Fri, 06 June 2008 12:02 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Did you ask Allround Automation?
After all, you pay them for support.

I would however offer them a tad more specific details..
Re: PL/SQL Developer Debugging Hangs [message #328161 is a reply to message #325557] Thu, 19 June 2008 02:43 Go to previous messageGo to next message
dboss
Messages: 1
Registered: June 2008
Junior Member
Hi,

did you try another client such
ACDB ( http://www.electronic-experience.net ).
This DB modeler have a very simple PL/SQL editor with a debugger.
You can download it for free ( the community edition is limited to 15 minutes /session).
Re: PL/SQL Developer Debugging Hangs [message #330186 is a reply to message #325557] Fri, 27 June 2008 16:16 Go to previous message
coleing
Messages: 213
Registered: February 2008
Senior Member
this is a well commented on problem with plsql developer, and you have obviously looked it up, as what you have done in the preferences is the suggested solution.

I get the problem periodically as well, and although I cant pinpoint it, it always seems to be packages which consume a lot of memory and use lots of arrays (which plsql developer debugger is rubbish with).
Previous Topic: what exactly is a complex flat file?
Next Topic: PL/SQL Code Prevent overwrite
Goto Forum:
  


Current Time: Sun Dec 04 18:28:03 CST 2016

Total time taken to generate the page: 0.07920 seconds