ORA-06502: PL/SQL: numeric or value error
If you are trying to use ODP.NET for your ASP.NET application, you may run into some compatibility with the version you are trying to use. For example, I ran into an issue trying to use the 11g provider for our Oracle 9i database server - ORA-06502: PL/SQL: numeric or value error
Resolution
Use the version release of ODP.NET that matches your database server version. We uninstalled the 11g provider and everything worked fine!
Link to ODP.NET
http://www.oracle.com/technology/tech/windows/odpnet/index.html
Resolution
Use the version release of ODP.NET that matches your database server version. We uninstalled the 11g provider and everything worked fine!
Link to ODP.NET
http://www.oracle.com/technology/tech/windows/odpnet/index.html
Labels: ASP.NET, ODP.NET, Ora-06502, Oracle 11g, Oracle 9i, PL/SQL numeric error

1 Comments:
I need to know from you how often does this error come up? In my case I had the similar configuration as mentioned, but was working well for a while and then this error comes up.
By
Hifni Shahzard Nazeer, at 11:19 PM
Post a Comment
<< Home