What are the common problems you expect to hit when you have to port an application from SqlServer to Oracle?
What are the best solutions to these problems?
(Please consider creating separate questions for detailed answers for each problem and linking to these questions.)
As I am from an ISV background, I am assuming the application will have to continue to support SQLSever as well as adding support for Oracle. Including all feature versions, so development/testing process will be part of the solution.