Web App Development

Monday, May 05, 2008

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

Labels: , , , , ,

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 Blogger Hifni Shahzard Nazeer, at 11:19 PM  

Post a Comment

<< Home