ORA-06502 sporatic error

[greg.mccarty]

Ok, here's the problem.

I've written approx 30 test scripts. Once done (of course), I realized that a lot of the dbms_output dumps were duplicated, so I put them in a package called DEBUG_MGMT. I then changed the scripts to call the appropriate procedure in that package.

When I run a script, I get an oracle ORA-06502 error, referencing a line 8 in my DEBUG_MGMT package. Line 8 is in the middle of a comment block.

If I then run the script again, it works - no error.

Open the next test script, hit F8, and get the same error. Hit F8 immediately, and it works.

Try to debug, and when I step into the DEBUG_MGMT procedure, I get the error. No amount of rerunning fixes this.

Any ideas?

Using version 6.0.5.931

 

[greg.mccarty]

Oops. Running against Oracle 9i 9.2.0.5

 

[greg.mccarty]

Ok, never mind. I have to post the question to find the answer.

Here was the problem.

In my package spec, I did the following

c_MyVal CONSTANT varchar2(2) := 'ALL';

This compiled !!

However, it was causing the problem. When I change the length to 3, the behavior went away.

Strange!