| Major problem with 10g upgrade [message #154989] |
Wed, 11 January 2006 11:11  |
Tony Grace
Messages: 23
Registered: August 2003
|
Junior Member |
|
|
We have a website (ASP Pages) that we had connected to our oracle 8i database. One of the columns in 8i was switched from 2000 to 4000 bytes (varchar2), last year and everything worked fine.
We just completed a migration from oracle 8i to oracle 10g r2.
All of a sudden we are getting an ora 06502 when trying to retrieve previous records that have over 2000 bytes in that 4000 column.
when we try to insert from the ASP page it gives us a numeric or value error.
The developers tested to ensure the procedure that is being called from the ASP page is working...they have test the input and out put and are getting the desired results....all the asp pages are doing are calling the procedure and passing the I/O...that seems to be working fine..
Therefore all fingers are pointingat a configuration issue either on the 10g database or perhaps with the ODBC driver that connects the ASP pages to the database. But we tried to install the 10G ODBC driver from oracle and still have the problem.
We have looked high and low and found nothing that can help...
Anyone have any ideas at all?
|
|
|
|
| Re: Major problem with 10g upgrade [message #155190 is a reply to message #154989] |
Thu, 12 January 2006 14:55  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
I'm not able to find ora 06502 on the oracle error list, several numbered right around it, but not it. Hmm just googled it, wonder why it isn't in my documentation set...
Anyway as far as the numeric or value error, typically has to do with data types or lengths. Make sure numbers are numbers, characters are characters, dates are dates. Don't rely on implicit type conversion. Make sure all variables used along the way are of sufficient length to hold the data that goes in them.
I'm not aware of anything in 10g that would cause something that used to work to stop working. Driver has issues or a setting that needs to be made, maybe, or code has issues somewhere in the procedure or elsewhere, but I don't know of anything with the new version that would do it.
I did just notice a bug in the google search, but it was for only version 9.2.0.6, supposedly fixed in 10.2.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
