Geek asks and answers

Can debug, but cannot check or view variables in Oracle's huge PlSql package

I have a "huge" Pl / Sql package (about 1.4 MB, about 30,000 lines) running in an Oracle database 10.2.0.4.0 - 64 bits on top of Solaris.

I can debug it step by step (the package is marked as debuggin), but my problem is that when I try to look or check any variable, the PL / Sql developer will show me "Not a variable" with any variable (varchar2, number, etc. .d.), even I can’t watch such things:

strTipo VARCHAR2(20)  := 'PRUEBA';

I can debug and observe / check variables in other small packages, but not in huge ones. dbms_output.put_line will go crazy.

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

Anyone if there is some kind of configuration option in Oracle, or what can I do?

Having a huge package less its not a solution for me. I can not do it.

Regards and thanks in advance.

+5
source share
2 answers

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

0
source

You can use;

DBMS_OUTPUT.PUT_LINE (variable);

-1
source

More articles:


All Articles