Turns out there was a difference in a column format between the 2 instances (truly "DUH"). It was a date field that was the culprit (which we strongly suspected).
Thanks for your willingness to help - you guys are the best!!
I have a procedure that compiles and runs in Oracle 9i, but encounters an error when run in Oracle 10gR2. It is failing on an INSERT statement, but I cannot figure out what is causing the problem. All datatypes are correct.
Has anyone else experienced this type of issue during your upgrade...
I ran into a problem using SQL*LDR that I've never experienced before. It appears that when the tab-delimited input file has consecutive fields that are null, they are treated as one field rather than several fields.
Here is a sample from my input file...
This was our experience also. We weren't able to run the Oracle 8i personal edition on Windows 2000 or Windows ME (or 95 either, I believe). It is only compatible with Windows 98 according to an Oracle instructor. However, there IS a version available that is compatible with newer Windows...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.