Print Thread
Debug -(Not a variable) Need Help
#22540 04/14/06 02:44 AM
Joined: Apr 2006
Posts: 3
S
sona Offline OP
Member
OP Offline
Member
S
Joined: Apr 2006
Posts: 3
I am USING PL/SQL developer 7.0.1
I have one package.in that i have one Procedure
I put break point and trying to complie and debug a variable-The tool tip shows up -->(Not a variable)

I right clicked the package and ADD DEBUG INFORMATION .Still i have same problem.

Funny part is what ever referenced procedures i go and debug this is working fine..

Any one have solution for this?

Re: Debug -(Not a variable) Need Help
#22541 04/14/06 06:53 PM
Joined: Aug 1999
Posts: 22,211
Member
Offline
Member
Joined: Aug 1999
Posts: 22,211
There are some restriction to the variables that can be displayed. It is restricted to scalar variables, or collections of a scalar data type. For compound data types such as records or objects you can only display the individual fields or attributes (record.field or object.attribute).


Marco Kalter
Allround Automations
Re: Debug -(Not a variable) Need Help
#22542 04/14/06 08:32 PM
Joined: Apr 2006
Posts: 3
S
sona Offline OP
Member
OP Offline
Member
S
Joined: Apr 2006
Posts: 3
The probelm is
i have declared a variable
lv_cnt NUMBER := 0; inside a procedure .
while debug The tool tip shows up lv_cnt is-->(Not a variable)

Re: Debug -(Not a variable) Need Help
#22543 04/17/06 07:30 PM
Joined: Sep 2003
Posts: 387
London, UK
Member
Offline
Member
Joined: Sep 2003
Posts: 387
London, UK
Is the procedure compiled for debug?

btw, why NUMBER and not INTEGER or PLS_INTEGER?

Re: Debug -(Not a variable) Need Help
#22544 04/18/06 10:09 PM
Joined: Aug 1999
Posts: 22,211
Member
Offline
Member
Joined: Aug 1999
Posts: 22,211
Is the variable already initialized when you inspect the value?


Marco Kalter
Allround Automations
Re: Debug -(Not a variable) Need Help
#22545 04/20/06 02:55 AM
Joined: Apr 2006
Posts: 3
S
sona Offline OP
Member
OP Offline
Member
S
Joined: Apr 2006
Posts: 3
Yes the Variable is already initialized , my code complied perfectly.

Re: Debug -(Not a variable) Need Help
#22546 04/20/06 09:17 PM
Joined: Aug 1999
Posts: 22,211
Member
Offline
Member
Joined: Aug 1999
Posts: 22,211
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: Debug -(Not a variable) Need Help
#22547 04/29/08 06:29 PM
Joined: Dec 2007
Posts: 7
Tilburg NBr
Member
Offline
Member
Joined: Dec 2007
Posts: 7
Tilburg NBr
I have the same problem.

not only regular variables seem not to be recognised, but none.. also "record.fieldname" I want to send the debug file you asked.. but how am I supposed to do that?

Re: Debug -(Not a variable) Need Help
#22548 04/30/08 03:47 PM
Joined: Aug 1999
Posts: 22,211
Member
Offline
Member
Joined: Aug 1999
Posts: 22,211
Is this a package? If so, can you explicitly add debug information to the package by right-clicking on it and selecting "Add debug information"? Retry the debugger after doing so.


Marco Kalter
Allround Automations

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.127s Queries: 13 (0.035s) Memory: 2.5317 MB (Peak: 3.0396 MB) Data Comp: Off Server Time: 2024-05-07 11:20:03 UTC
Valid HTML 5 and Valid CSS