|
'NOT A VARIABLE' is show
|
Joined: Mar 2014
Posts: 5
Member
|
OP
Member
Joined: Mar 2014
Posts: 5 |
Hi,,,,, I have a problem...
I have 1 packages (and I've added debug information in my packages) and also PLSQL_DEBUG = TRUE
When call a procedure within a package body and then placing cursor to variables, instead of value shown, 'NOT A VARIABLE' is shown...
I have other old database... i have tested it... it's working... (different script, not same)
any idea?
Thanks
|
|
|
Re: 'NOT A VARIABLE' is show
|
Joined: Mar 2011
Posts: 237 Russia
Member
|
Member
Joined: Mar 2011
Posts: 237 Russia |
This happens then and now. Could you 'Add debug information' over again?
Best regards, Maxim
|
|
|
Re: 'NOT A VARIABLE' is show
|
Joined: Mar 2014
Posts: 5
Member
|
OP
Member
Joined: Mar 2014
Posts: 5 |
Hi! I have tried twice but still same.
Any idea?
|
|
|
Re: 'NOT A VARIABLE' is show
|
Joined: Mar 2011
Posts: 237 Russia
Member
|
Member
Joined: Mar 2011
Posts: 237 Russia |
Sorry, no ideas remain
Best regards, Maxim
|
|
|
Re: 'NOT A VARIABLE' is show
|
Joined: Sep 2009
Posts: 197 Krakow, Poland
Member
|
Member
Joined: Sep 2009
Posts: 197 Krakow, Poland |
Try using "Add debug info" in object tree on package specification and also on package body. Helped me sometimes.
|
|
|
Re: 'NOT A VARIABLE' is show
|
Joined: Apr 2011
Posts: 49
Member
|
Member
Joined: Apr 2011
Posts: 49 |
i have the same issue on occasion. i think it is related to the size of the package. i also recall someone saying that this could happen if the are 'too many' variables, though can't say how many is too many. Could also be related to database structure sizes, e.g., even though you are instructing oracle to add debug info, there isn't enough room for all the debug info. break points are also not working, right? but you can step into the code, right?
|
|
|
Re: 'NOT A VARIABLE' is show
|
Joined: Mar 2014
Posts: 5
Member
|
OP
Member
Joined: Mar 2014
Posts: 5 |
[quote=archer]i have the same issue on occasion. i think it is related to the size of the package. i also recall someone saying that this could happen if the are 'too many' variables, though can't say how many is too many. Could also be related to database structure sizes, e.g., even though you are instructing oracle to add debug info, there isn't enough room for all the debug info. break points are also not working, right? but you can step into the code, right?[/quote]
FYI, My old database's package is larger (1.14MB... all procedures & functions in one package body..) and able to show value when call a procedure within a package body... no problem.. But in new database... The existing new package is same as old package (1.14MB) except some additional code only... so not able to show value (NOT A VARIABLE) when call a procedure within a package body..... Two databases which both have the same level...the version is same...
Last edited by Jeff LSY; 04/01/14 02:51 PM.
|
|
|
Re: 'NOT A VARIABLE' is show
|
Joined: Mar 2014
Posts: 5
Member
|
OP
Member
Joined: Mar 2014
Posts: 5 |
[quote=Hilarion]Try using "Add debug info" in object tree on package specification and also on package body. Helped me sometimes.[/quote]
I have tried twice but still same.... :-(
|
|
|
Re: 'NOT A VARIABLE' is show
|
Joined: Sep 2009
Posts: 197 Krakow, Poland
Member
|
Member
Joined: Sep 2009
Posts: 197 Krakow, Poland |
I have no idea if what archer suggested is right or not, but if it is, than still what you wrote may not rule out this cause. Maybe physical (or virtual) server configurations differ between those Oracle Database systems and/or some Oracle DB configuration parameters differ (like SGA and/or PGA sizes).
What you could test, to make sure if the cause is on the DB side or on PL/SQL Developer side, is to use some another tool (like free "Oracle SQL Developer" from Oracle) to debug that code and check if the problem still occurs.
Last edited by Hilarion; 04/01/14 03:20 PM. Reason: Added last paragraph.
|
|
|
Re: 'NOT A VARIABLE' is show
|
Joined: Mar 2014
Posts: 5
Member
|
OP
Member
Joined: Mar 2014
Posts: 5 |
[quote=Hilarion]I have no idea if what archer suggested is right or not, but if it is, than still what you wrote may not rule out this cause. Maybe physical (or virtual) server configurations differ between those Oracle Database systems and/or some Oracle DB configuration parameters differ (like SGA and/or PGA sizes).
What you could test, to make sure if the cause is on the DB side or on PL/SQL Developer side, is to use some another tool (like free "Oracle SQL Developer" from Oracle) to debug that code and check if the problem still occurs.[/quote]
Oh Maybe.. Ok noted, i try figure out why.... Thank you to archer and Hilarion...
|
|
|
|
|
|