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 from 9i to 10g? Any ideas why it's happy in 9i but not 10g?
TIA
Has anyone else experienced this type of issue during your upgrade from 9i to 10g? Any ideas why it's happy in 9i but not 10g?
TIA