This is the result of a prior thread but this question was never answered.Do you have a small sample of a BaseBoSql that would be used as the base business object. Then as you indicated a "useOracleFlag" that would indicate in this BaseBOSql that would tell the BaseBoSql that it needs to use Oracle (BaseBoOracle) and that the BaseBoSql would be instructed to have it's code where it varies to be overridden by the BaseBoOracle business object? Just taking a small sample of a SQL Database "MyDatabase" with a "tbl_Customer" table with 2 columns "customer_Id" and "customer_Name". The Oracle database would be named exactly the same as the SQL Database, sample table and column names and the same case (upper/lower). If you could show a sample code of how to accomplish this, I am sure it would be helpful to others.
I could also heavily modify the mapped bo to use the "useOracleFlag" to include "IF" sections for the generated SQL specific commands or the Oracle commands. Unfortunately, regardless of which approach is taked, it appears that once this is done, you could never regenerate the BO from the database again.