Custom Search . . .

Thursday, November 13, 2008

ORA-06502: PL/SQL: numeric or value error

Hello,

Database Version: 10.2.0.3
Os: Sun Solaris 5.9

Recently we upgrated our production database 9.2 to 10.2.0.3 & I got below error in my production environment.

On the Application builder page, when attempting to click details to view the applications, the following error occurs:

ORA-06502: PL/SQL: numeric or value error: NULL index table key value

Permanent solution:Upgrade database to 10.2.0.4 or above


OR


Download and apply database
Patch 5705795. If the version for your database is not available , create a new Service request from metalink under product RDBMS to request for a patch

2 comments:

Unknown said...

Hi,

How did you determine that this patch will fix the problem. I see a couple APEX forum post that discuss this problem, but I didn't see any that mention this patch as a solution.

Thanks!
Ken

Babu said...

Thanks for your comment.

Can you tel me some details; I'll explain you.

1/ what's your database version (4 digit)

2/ What's your OS Version ?

Babu