Hi all,
This is my info ;

PL/SQL Developer
Version 9.0.2.1621
01.421632 - Unlimited user license
Windows 7 (64-bit) 6.1 Build 7601 (Service Pack 1)

Physical memory : 4.054.136 kB (1.275.792 available)
Paging file : 4.194.304 kB (3.867.372 available)
Virtual memory : 2.097.024 kB (1.710.352 available)

Parameters
C:\Program Files\PLSQL Developer902\plsqldev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False
Allow Multiple Connections: False

Preference Files
C:\Users\sergul\AppData\Roaming\PLSQL Developer\Preferences\default\Default.ini
C:\Users\sergul\AppData\Roaming\PLSQL Developer\Preferences\sergul\default.ini

Plug-Ins
*PL/SQL Documentation (plsqldoc) (C:\Program Files\PLSQL Developer902\PlugIns\plsqldoc.dll)
*Red Gate Deployment Plug-In (C:\Program Files\PLSQL Developer902\PlugIns\RedGate.dll)
*Version Control Interface 1.2 (C:\Program Files\PLSQL Developer902\PlugIns\VCS.dll)
(* is Active)

Aliases
ACE
ACE_L
AVIVA_VZX
AVIVATEST
BEHTCON
...

Homes
OraClient11g_home1 (C:\oracle)

DLLs
C:\oracle\bin\oci.dll

TNS File
C:\oracle\Network\Admin\tnsnames.ora

Using
Home: OraClient11g_home1
DLL: C:\oracle\bin\oci.dll
OCI: version 11.1
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0

Character Sets
Character size: 1 byte(s)
CharSetID: 39
NCharSetID: 2000
Unicode Support: True
NLS_LANG: TURKISH_TURKEY.TR8MSWIN1254
NLS_CHARACTERSET: WE8ISO8859P9
NLS_NCHAR_CHARACTERSET: AL16UTF16


While debugging a procedure in a package, coming over a variable, shows "not a variable".

Hello serelay, have you tried to rightclick on the package and choose "Add debug information"? Of what type is the variable (parameter, local variable, record, array, public/private etc.)?

yes i did. Also "Add debug information when compilig" parameter is checked. This is seriously suffering staff to debug. We have to code every variable or parameter with dbms_output.

Can you let me know the variable type?

best guess:
package is too large vs the amount of ram allocated to Oracle. package compiles OK but there's not enough room to add all the debug info. can only step through code but inspecting any variable does not work.

does this sound familiar? try debugging a smaller package and see if things work

solutions???
- allocate more ram to oracle.
- split package into smaller packages

i tried a smaller package. but it is same. it shows "not a variable".
Maybe the problem is my version, downloaded the last release, nothing changed.

sorry, didn't see the previous message..

the variable types are ; varchar2, number, date

Maybe "archer" is into something about the size of the package. I have experienced that there are two things that can make a package too big for Oracle to handle. The one thing, as archer has stated, is size. The other thing is the actual number of package variables, constants, types, methods etc. (private and public). If this number becomes too large, it can also inflict on how well Oracle can compile and debug the package.

"serelay", can you please tell us the number of public (package header) and private (package body) variables, constants, types, functions, procedures etc. your package have, respectively. Also, what types of parameters are your package methods typically called with (type of parameters, number of parameters, function/procedure, number of in, out, and in/out parameters etc.)

any news?

Hi,

I have exactly the same problem in 2-3 packages (and I've added debug information in my packages). The size of the package is "reasonnable": about 2700 lines and 50 procedures.

@Marco: I could send you a debug.txt file, but I need a email address for that. I cannot post it on Internet.

Thanks,

Laurent