5

I've got a "huge" Pl/Sql package (about 1.4 Mb, about 30.000 lines) running in Oracle database 10.2.0.4.0 - 64bit over Solaris.

I can debug it step by step (package is marked as debuggin) but my problem is when I try to watch or inspect any variable, PL/Sql developer show me "Not a Variable" with any variable (varchar2, number, etc ) even I cant watch stuff like this:

strTipo VARCHAR2(20)  := 'PRUEBA';

I can debug and watch/inspect variables in other small packages, but not in the huge one. dbms_output.put_line is going to drive me crazy.

Many nodes? Oracle can't allocate memory for varibles?

Does anybody if there is some configuration parameter in Oracle or what can I do?

Do the huge package smaller its not a solution for me. I can't do it.

Regards and Thanks in advance.

Alex
  • 51
  • 1
  • 3
  • don't think the issue is with Oracle, but pl/sql Developer IDE. Sounds dumb, but try rebooting your local machine running pl/sql developer. – tbone Sep 07 '12 at 12:53
  • @tbone - WE ARE MICROSOFT OF BORG! PREPARE TO BE REBOOTED!! :-) – Bob Jarvis - Слава Україні Sep 07 '12 at 16:58
  • 2
    It is not a Reboot problem, and I think It is not a pl/sql Developer problem because with TOAD I have the same problem. I think It is a Oracle restriction maybe many nodes, many variables in memory or something like that. But I don't Know how can I check it to discard. Thanks. – Alex Sep 10 '12 at 08:32
  • I would definitely try running the debugging code manually through SQL*Plus or SQL Developer -- maybe you are missing an error or informational message, or other clue. – David Aldridge Jan 16 '14 at 12:58

2 Answers2

1

The package body is just too big. Divide it in several packages. There are also some limits of the plsql engine see here: http://docs.oracle.com/cd/B19306_01/appdev.102/b14261/limits.htm (10g documentation)

Vimal Bhaskar
  • 748
  • 1
  • 5
  • 17
db2java
  • 11
  • 1
0

You can use;

DBMS_OUTPUT.PUT_LINE(variable);

Mehmet
  • 2,256
  • 9
  • 33
  • 47