Developing CF with Oracle

[programmher]

My company is migrating over to Oracle. We will remain with CF web development. What differences can I expect with Oracle? I've consulted both the Allaire and Oracle websites, but did not locate anything helpful. My CF 4.5 book only had a few, vague references...I would appreciate any insight.

 

[GunJack]

As far as your CF development goes, about the only difference you should see are in the SQL functions Oracle supports and some potential differences in field definitions. I've never use Oracle but most everything should work the same under the new database. If you're using SQL server and use some of the sql functions such as min(),max(), etc.., you may find some are only supported inside SQL server and code using them may break under Oracle. I only use min and max functions as an example as I think they are universally supported but I believe SQL server has a lot of other functions that are MS only functions. You may find that certain default behavior is different under Oracle than your current db. Things like default values, default sort orders may be different and may cause you problems if you don't specify them explicity.

All in all, things should work the same but I've just listed a few things I can think of that aren't always the same across databases.

GJ