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 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.