I have a piece of code in Pro-C that's been running under Oracle 9i for several years.
I recently compiled it using the ProC of Oracle 10g and the code complied without any problems. However, when I run it on an Oralce 10g database, queries that returned thousands of records in 9i return empty record sets in 19g. I ran the same queries in SqlPlus and got the expected results. Note that the query is a simple select with a single join statement.
Does anyone have any idea what might cause this?
February 19, 2009 2:31 PM
February 26, 2009 1:46 PM