Print Thread
Page 1 of 2 1 2
View collection variables in debugger?
#26441 05/21/07 06:11 PM
Joined: Dec 2005
Posts: 132
Leoben,Austria
D
Member
OP Offline
Member
D
Joined: Dec 2005
Posts: 132
Leoben,Austria
When I'm trying to "view collection variables" in the debugger nothing happens. I'd expect either an error message or the view to appear.
(PLSD 7.1.1.1339)

Re: View collection variables in debugger?
#26442 05/22/07 09:33 PM
Joined: Aug 1999
Posts: 22,219
Member
Offline
Member
Joined: Aug 1999
Posts: 22,219
To obtain some more diagnostic information, can you modify the shortcut and add the debugsql parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" debugsql

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory.


Marco Kalter
Allround Automations
Re: View collection variables in debugger?
#26443 05/22/07 10:01 PM
Joined: Jul 2004
Posts: 592
W
Member
Offline
Member
W
Joined: Jul 2004
Posts: 592
I got the same result when trying to "view collection variables" on a package that didn't have debug info. Adding debug info resolved it.

Re: View collection variables in debugger?
#26444 05/23/07 12:51 PM
Joined: Dec 2005
Posts: 132
Leoben,Austria
D
Member
OP Offline
Member
D
Joined: Dec 2005
Posts: 132
Leoben,Austria
I have sent the debug.txt.
Worker's solution is not working for me either.
An additional hint: "view collection variable" is enabled almost everywhere in the test window ( not only for collections).

Re: View collection variables in debugger?
#26445 05/24/07 12:50 AM
Joined: Dec 2005
Posts: 132
Leoben,Austria
D
Member
OP Offline
Member
D
Joined: Dec 2005
Posts: 132
Leoben,Austria
As debug.txt does not help here ... can I do something else to isolate the problem?
I have already tried:
recompiled again to ensure debuginfo is really there
used dual session instead of multi session
granted dba to the debugging user
XP/Home + XP/Professional platform for PLSD
Changed plsd to automatic home selection
even installed 1341
As far as I remember (but I 'm not sure) simple collections used to work with 7.0.3.

Re: View collection variables in debugger?
#26446 05/25/07 07:31 PM
Joined: Sep 2004
Posts: 476
Munich, Germany
Member
Offline
Member
Joined: Sep 2004
Posts: 476
Munich, Germany
I have the same problem. We user version 7.1.0.1337
In a package we have an associated array variable of type:
TYPE my_visit_array_type IS TABLE OF NUMBER
INDEX BY VARCHAR2 (10);
When trying to debug the variable using right click "View Collection Variable" nothing happens. When I do "Add Variable to Watches" it gets added and as value just shows (Collection). When I click on the "..." field there a Text Editor window opens and in it again just the text: (Collection).
I also remember that it worked watching collection variables in debug in the previous version. Hope that helps to sort out the problem.
Best Regards,
Berny


Regards,
Berny
Re: View collection variables in debugger?
#26447 05/29/07 11:58 AM
Joined: Jun 2003
Posts: 52
Lenzburg, Switzerland
T
til Offline
Member
Offline
Member
T
Joined: Jun 2003
Posts: 52
Lenzburg, Switzerland
Well for me it works, as long as the variable is not a parameter or has been assigend the value of a parameter. When that is the case, and i want to inspect the collection, plsql develpoer completly hangs though frown

Re: View collection variables in debugger?
#26448 05/29/07 12:09 PM
Joined: Jun 2003
Posts: 52
Lenzburg, Switzerland
T
til Offline
Member
Offline
Member
T
Joined: Jun 2003
Posts: 52
Lenzburg, Switzerland
Looks like that works with a oracle 10 db though, it only hangs on a 9.2

Re: View collection variables in debugger?
#26449 05/29/07 05:25 PM
Joined: Dec 2005
Posts: 132
Leoben,Austria
D
Member
OP Offline
Member
D
Joined: Dec 2005
Posts: 132
Leoben,Austria
My database version is 10.2.0.2 and it doesn't hang for me either, it simple does'nt work (but til is right: it is possible to create a test case with a "local only" collection where it is working)
But it would be nice to make it work like the "inspect" function of Oracle's SQL-developer...

Re: View collection variables in debugger?
#26450 05/30/07 02:35 PM
Joined: Jun 2003
Posts: 52
Lenzburg, Switzerland
T
til Offline
Member
Offline
Member
T
Joined: Jun 2003
Posts: 52
Lenzburg, Switzerland
Possibly it depends not only on the db version, but also on the sqlnet version. I've seen collection related problems depending on sqlNet.

Page 1 of 2 1 2

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.031s Queries: 14 (0.007s) Memory: 2.5592 MB (Peak: 3.0420 MB) Data Comp: Off Server Time: 2024-05-15 10:04:17 UTC
Valid HTML 5 and Valid CSS